ExcelBanter - Lookup table returns #N/A

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Lookup table returns #N/A (https://www.excelbanter.com/excel-discussion-misc-queries/69149-lookup-table-returns-n.html)

Kimberly Bassininsky

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

Niek Otten

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

Alan

Lookup table returns #N/A

=IF(ISNA(VLOOKUP(A1,H1:I1000,2,FALSE)),"Zero, blank or error
message",VLOOKUP(A1,H1:I1000,2,FALSE))
Regards,
Alan.
"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

All times are GMT +1. The time now is 07:43 PM.