ISERROR on VLOOKUP


B

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
 
Ad

Advertisements

D

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

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
 
Ad

Advertisements

B

b1llt

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top