software

I have am using a lookup formula that when there is no exact match it
returns quot;#n/aquot;. I want it to return either a zero or remain blank if there
is no match. I know there is a way to change my lookup formula to
accomplish this but I can remember how.

Any help would be appreciated.

Thanks,
Kim
=IF(ISNA(YourFormula),quot;quot;,YourFormula)

--
Kind regards,

Niek Otten

quot;Kimberly Bassininskyquot; gt; wrote in message
...
gt;I have am using a lookup formula that when there is no exact match it
gt; returns quot;#n/aquot;. I want it to return either a zero or remain blank if
gt; there
gt; is no match. I know there is a way to change my lookup formula to
gt; accomplish this but I can remember how.
gt;
gt; Any help would be appreciated.
gt;
gt; Thanks,
gt; Kim
gt;
gt;
=IF(ISNA(VLOOKUP(A1,H1:I1000,2,FALSE)),quot;Zero, blank or error
messagequot;,VLOOKUP(A1,H1:I1000,2,FALSE))
Regards,
Alan.
quot;Kimberly Bassininskyquot; gt; wrote in message
...
gt;I have am using a lookup formula that when there is no exact match it
gt; returns quot;#n/aquot;. I want it to return either a zero or remain blank if
gt; there
gt; is no match. I know there is a way to change my lookup formula to
gt; accomplish this but I can remember how.
gt;
gt; Any help would be appreciated.
gt;
gt; Thanks,
gt; Kim
gt;
gt;