Andy,

It is returning NA because it didn't find the value from cell A79.

Generally, wrap your first check in an ISERROR function:

=IF($A790,IF(ISERROR(VLOOKUP($A79,'BO
Output'!$A$3:$P$2002,4,FALSE)),"",VLOOKUP($A79,'BO
Output'!$A$3:$P$2002,4,FALSE)),"")

HTH,
Bernie
MS Excel MVP


"andy" wrote in message
...
We are using the following formula and it returns N/A
=IF($A790,IF(VLOOKUP($A79,'BO
Output'!$A$3:$P$2002,4,FALSE)="","",VLOOKUP($A79,' BO
Output'!$A$3:$P$2002,4,FALSE)),"")

How do i use isna function with this formula
--
andy