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