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

See More: Vlookup Blank result

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.


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


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

Report •
Related Solutions

Ask Question