I'm using the following formula but am getting #N/A values on some of the
cells:
=VLOOKUP(VALUE(LEFT(B88,5)),List!A:C,3,0)

I would like it to return "empty" when it returns an error value. I tried
the following but it still returns #N/A:
=VLOOKUP(ISERROR(LEFT(B88,5)),List!A:C,3,0)

Please let me know if there is another way to use the ISERROR function to
get the "empty" to return as my value if there is an error.
Thanks,
b1llt

I think...

=if(isna(VLOOKUP(VALUE(LEFT(B88,5)),List!A:C,3,0)) ,"",
VLOOKUP(VALUE(LEFT(B88,5)),List!A:C,3,0))

xl2007 has a new =iferror() function

=iferror(VLOOKUP(VALUE(LEFT(B88,5)),List!A:C,3,0), "")



b1llt wrote:

I'm using the following formula but am getting #N/A values on some of the
cells:
=VLOOKUP(VALUE(LEFT(B88,5)),List!A:C,3,0)

I would like it to return "empty" when it returns an error value. I tried
the following but it still returns #N/A:
=VLOOKUP(ISERROR(LEFT(B88,5)),List!A:C,3,0)

Please let me know if there is another way to use the ISERROR function to
get the "empty" to return as my value if there is an error.
Thanks,
b1llt

--

Dave Peterson

Thy this:

=IF(ISERROR(VLOOKUP(VALUE(LEFT(B88,5)),List!A:C,3, 0)),"",VLOOKUP(VALUE(LEFT(B88,5)),List!A:C,3,0))

OR

If you are using XL2007
=IFERROR(VLOOKUP(VALUE(LEFT(B88,5)),List!A:C,3,0), "")

Hope this helps.
rzink

"b1llt" wrote:

I'm using the following formula but am getting #N/A values on some of the
cells:
=VLOOKUP(VALUE(LEFT(B88,5)),List!A:C,3,0)

I would like it to return "empty" when it returns an error value. I tried
the following but it still returns #N/A:
=VLOOKUP(ISERROR(LEFT(B88,5)),List!A:C,3,0)

Please let me know if there is another way to use the ISERROR function to
get the "empty" to return as my value if there is an error.
Thanks,
b1llt

Thanks a lot! Both yours and Dave's work great! I appreaciate being able to
rely on you guys as resources.
-b1llt

"rzink" wrote:

Thy this:

=IF(ISERROR(VLOOKUP(VALUE(LEFT(B88,5)),List!A:C,3, 0)),"",VLOOKUP(VALUE(LEFT(B88,5)),List!A:C,3,0))

OR

If you are using XL2007
=IFERROR(VLOOKUP(VALUE(LEFT(B88,5)),List!A:C,3,0), "")

Hope this helps.
rzink

"b1llt" wrote:

I'm using the following formula but am getting #N/A values on some of the
cells:
=VLOOKUP(VALUE(LEFT(B88,5)),List!A:C,3,0)

I would like it to return "empty" when it returns an error value. I tried
the following but it still returns #N/A:
=VLOOKUP(ISERROR(LEFT(B88,5)),List!A:C,3,0)

Please let me know if there is another way to use the ISERROR function to
get the "empty" to return as my value if there is an error.
Thanks,
b1llt