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.