Solved Vlookup Blank result

January 15, 2012 at 06:11:38
Specs: Windows XP
I want to the result to be blank instead of #N/A
How can I make this to blank result if vlookup doenst match. Thanks
=VLOOKUP(I94,$A:$E,0,FALSE)

See More: Vlookup Blank result

Report •

#1
January 15, 2012 at 07:32:12
✔ Best Answer
Does your VLOOKUP even work?

I don't believe that you can use a 0 as the col_index_num. Since there is no Column 0 in a range, doesn't the function return a #VALUE error?

In any case, the standard way to avoid seeing the #N/A error is to wrap an IF function around your VLOOKUP.

Note that I changed your formula so that it uses a valid col_index_num argument of 3.

=IF(ISNA(VLOOKUP(I94,$A:$E,3,FALSE)),"",VLOOKUP(I94,$A:$E,3,FALSE))

or, since 0 and 1 can be used as the range_lookup argument...

=IF(ISNA(VLOOKUP(I94,$A:$E,3,0)),"",VLOOKUP(I94,$A:$E,3,0))

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question