Thread: If (Vlookup 0) working, but what if Vlookup cell does not exist
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Héctor Miguel Héctor Miguel is offline
external usenet poster
  
Posts: 434
Default If (Vlookup 0) working, but what if Vlookup cell does not exist
hi, Steve !

This formula works if the data is present, however, I'm getting #N/A if the lookup cell (A4) doesn't exist, which it may not on some days.

=IF(VLOOKUP(A4,Sat!$A$16:$J$377,9,FALSE)0,VLOOKUP (A4,Sat!$A$16:$J$377,9,FALSE),"")

Can this formula be modified to also produce "" if the data representing A4 does not exist ?

i.e. =if(countif(sat!$a$16:$a$377,a4),vlookup(a4,sat!$a $16:$j$377,9,0),"")

hth,
hector.


Reply With QuoteReply With Quote