ISERROR on VLOOKUP

[b1llt]

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]

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

 

[rzink]

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]

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