ExcelBanter - VLOOKUP #NA

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - VLOOKUP #NA (https://www.excelbanter.com/excel-programming/385683-vlookup-na.html)

Tufail

VLOOKUP #NA

hello,
i am using vlookup formula but when cell is empty #na error is coming out is
there any other way ?

=IF(A100="","",VLOOKUP(A100,spl,12,))

thanks in advance.

Vergel Adriano

VLOOKUP #NA

VLOOKUP will return #NA if the value is not found. Try it this way to avoid
showing #NA.

=IF(A100="","",IF(ISNA(VLOOKUP(A100,spl,12,)),"",V LOOKUP(A100,spl,12,)))

or just like this:

=IF(ISNA(VLOOKUP(A100,spl,12,)),"",VLOOKUP(A100,sp l,12,))

--

Hope that helps.

Vergel Adriano

"Tufail" wrote:

hello,
i am using vlookup formula but when cell is empty #na error is coming out is
there any other way ?

=IF(A100="","",VLOOKUP(A100,spl,12,))

thanks in advance.

Tufail

VLOOKUP #NA

thank you very much for your reply.

"Vergel Adriano" wrote:

VLOOKUP will return #NA if the value is not found. Try it this way to avoid
showing #NA.

=IF(A100="","",IF(ISNA(VLOOKUP(A100,spl,12,)),"",V LOOKUP(A100,spl,12,)))

or just like this:

=IF(ISNA(VLOOKUP(A100,spl,12,)),"",VLOOKUP(A100,sp l,12,))

--

Hope that helps.

Vergel Adriano

"Tufail" wrote:

hello,
i am using vlookup formula but when cell is empty #na error is coming out is
there any other way ?

=IF(A100="","",VLOOKUP(A100,spl,12,))

thanks in advance.

All times are GMT +1. The time now is 11:15 PM.