Lookup table returns #N/A
=IF(ISNA(YourFormula),"",YourFormula)
--
Kind regards,
Niek Otten
"Kimberly Bassininsky" wrote in message
...
I have am using a lookup formula that when there is no exact match it
returns "#n/a". 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
|