Excel 2007: Vlookup - Results without #N/A

[ocean mist]

in my results column, I have a series of #N/A where there is no result. Is
there anyway to have that left blank unless there IS a value to return?

 

[JLatham]

Yes, "wrap" your VLOOKUP() in a test for the error. There is a specific test
for the #N/A error:

example formula that could return #N/A: =VLOOKUP(A1,Sheet2!B1:Z1000,23,False)
wrapped up to prevent the display:
=IF(ISNA(VLOOKUP(A1,Sheet2!B1:Z1000,23,False)),"",VLOOKUP(A1,Sheet2!B1:Z1000,23,False))

 

[ryguy7272]

What type of function are you using? Vlookup? See this for a way to manage
your results:
http://www.techonthenet.com/excel/formulas/vlookup.php

Also, search help for =ISNA()

 

[ocean mist]

Yea!! Worked like a charm. Thank you so much!

Yes, "wrap" your VLOOKUP() in a test for the error. There is a specific test
for the #N/A error:

example formula that could return #N/A: =VLOOKUP(A1,Sheet2!B1:Z1000,23,False)
wrapped up to prevent the display:
=IF(ISNA(VLOOKUP(A1,Sheet2!B1:Z1000,23,False)),"",VLOOKUP(A1,Sheet2!B1:Z1000,23,False))

 

[T. Valko]

If you're using Excel 2007...

=IFERROR(VLOOKUP(.....),"")