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