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)

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_numargument 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_lookupargument...=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.

Ask Your Question

Weekly Poll

Do you think manufacturers should do more to reduce phone and tablet usage among kids?

Discuss in The Lounge

Poll History