It's still producing the #N/A when the data in the A4 cell not on the Sat
tab. Also, the when it is on the Sat tab, it won't be in Sat!A4, in fact, it
may be anywhere in the A column.

Thanks,

Steve

"Dan" wrote:

On Nov 18, 8:58 am, Steve wrote:
I guess I wasn't too clear, because the A4 on this sheet will always be
there. It's the A4 lookup on Sat that may or may not be there.

Thaanks,

Steve



"Dan" wrote:
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(A 4,Sat!$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))
.- Hide quoted text -

- Show quoted text -

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

This will test both A4 on the current sheet and A4 on the sheet Sat
.