If (Vlookup 0) working, but what if Vlookup cell does not exi
This one is still coming up #N/A.
Thanks,
Steve
"Sean Timmons" wrote:
=IF(OR(iISNA(VLOOKUP(A4,Sat!$A$16:$J$377,9,FALSE)) ,VLOOKUP(A4,Sat!$A$16:$J$377,9,FALSE)=0),"",VLOOKU P(A4,Sat!$A$16:$J$377,9,FALSE))
"Steve" wrote:
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 ?
Thanks,
Steve
|