Lookup table returns #N/A

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

=IF(ISNA(YourFormula),"",YourFormula)

--
Kind regards,

Niek Otten

"Kimberly Bassininsky" <kimberly_999@hotmail.com> wrote in message
news:uhBly2CKGHA.3912@TK2MSFTNGP10.phx.gbl...
>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
>
>

=IF(ISNA(VLOOKUP(A1,H1:I1000,2,FALSE)),"Zero, blank or error
message",VLOOKUP(A1,H1:I1000,2,FALSE))
Regards,
Alan.
"Kimberly Bassininsky" <kimberly_999@hotmail.com> wrote in message
news:uhBly2CKGHA.3912@TK2MSFTNGP10.phx.gbl...
>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
>
>