Vlookup and #na

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Thanks to J.E., I have the following formula

=IF(ISNA(MATCH(Q$3,'1A'!$9:$9,FALSE)),"",VLOOKUP($A4,'1A'!$A:$AH,MATCH(Q$3,'1A'!$9:$9,FALSE),FALSE)

I need to prevent #NA from showing when $A4 is blank. :)

Ty much
 
Try:

=IF(ISNA(MATCH(Q$3,'1A'!9:9,FALSE)),"",IF(ISBLANK($A4),"",VLOOKUP($A4,'1A'!$
A:$AH,MATCH(Q$3,'1A'!9:9,FALSE),FALSE)))

(added another layer of IF() with ISBLANK($A4) returning "")
 
One way

=IF(ISNA(MATCH(Q$3,'1A'!$9:$9,0)),"",IF($A4="","",VLOOKUP($A4,'1A'!$A:$AH,MA
TCH(Q$3,'1A'!$9:$9,0),0)))
 
Back
Top