I need to write a formula for a VLOOKUP to put 0 instead of #N/A .

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to write a formula in excel to put a 0 instead of #N/A when my
VLOOKUP formula does not find data in the lookup area.
 
BBanalyst said:
I am trying to write a formula in excel to put a 0 instead of #N/A when my
VLOOKUP formula does not find data in the lookup area.

The standard way to do this is:

=IF(ISNA(VLOOKUP(....)),0,VLOOKUP(....))

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *
 
BBanalyst said:
I am trying to write a formula in excel to put a 0 instead of #N/A when my
VLOOKUP formula does not find data in the lookup area.

Try this
=IF(ISERROR(VLOOKUP(A1,B1:D10,2,FALSE))=TRUE,0,VLOOKUP(A1,B1:D10,2,FALSE))
 
Back
Top