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?

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))


"ocean mist" wrote:

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?

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

"JLatham" wrote:

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))


"ocean mist" wrote:

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?

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()

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"ocean mist" wrote:

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?

If you're using Excel 2007...

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

--
Biff
Microsoft Excel MVP


"ocean mist" wrote in message
...
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?