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