In some cases it is returning <blank, as desired, and in other cases it
returns "0". Does anyone know why??

"Roger Govier" wrote:

Hi Andy

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


--

Regards
Roger Govier

"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