You could apply conditional formatting to the cell such that if the
content is 0 then use a foreground colour of white (which on a white
background will make the cell appear blank).

Hope this helps.

Pete

On Jan 18, 7:16*pm, Mark wrote:
yes, it is finding the cell - if I plug in a value it works fine. How can I
force it to find a blank instead of a 0? Do I need to format the cells?



"Pete_UK" wrote:
You might have an empty cell in your table which is being found
correctly, but Excel returns it as zero rather than "".

Hope this helps.

Pete

On Jan 18, 7:01 pm, Mark wrote:
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- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -