lundi 22 juin 2020

I have to input IFERROR into an if function so it spits out that Instrument is not listed, . Im not sure why its not calculating it correctly

this is the original given formula: =IF(E3=3,VLOOKUP(H3,'Rental Information'!$A$3:$D$7,2,FALSE),VLOOKUP('Rental Data'!H3,'Rental Information'!$A$3:$D$7,3,FALSE))

and this is what i did: =IFERROR(IF(E2=3,VLOOKUP(H2,'Rental Information'!$A$3:$D$7,2,FALSE),VLOOKUP('Rental Data'!H2,'Rental Information'!$A$3:$D$7,3,FALSE),"Instrument not listed"))

but it is showing that ive inputted too many arguments.

Aucun commentaire:

Enregistrer un commentaire