On Nov 17, 5:08*am, "Bernard Liengme"
wrote:
Thanks, Biff. Too little coffee today!
Bernard

"T. Valko" wrote in message

...



You have to separate the OR conditions.

If ISNA is TRUE then the separate VLOOKUP will return #N/A causing the OR
to fail.

=IF(ISNA(VLOOKUP(A4,Sat!$A$16:$J$377,9,0)),"",IF(V LOOKUP(A4,Sat!$A$16:$J$37*7,9,0)=0,"",VLOOKUP(A4,S at!$A$16:$J$377,9,0)))

--
Biff
Microsoft Excel MVP

"Bernard Liengme" wrote in message
...
=IF(OR(ISNA(VLOOKUP(A4,Sat!$A$16:$J$377,9,FALSE)),
VLOOKUP(A4,Sat!$A$16:$J$377,9,FALSE=0,"",VLOOKUP(A 4,Sat!$A$16:$J$377,9,FALS*E))
best wishes
--
Bernard Liengme
http://people.stfx.ca/bliengme
Microsoft Excel MVP

"Steve" wrote in message
...
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,FA*LSE),"")

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

Thanks,

Steve- Hide quoted text -

- Show quoted text -

Would you not be better to test if A4 is blank rather than testing the
result of the VLookup formula? Using ISNA will filter genuine NA
messages too.

=IF(ISBLANK(A4),"",VLOOKUP(A4,Sat!$A$16:$J$377,9,F A*LSE))