Vlookup

  • Thread starter Thread starter Kali
  • Start date Start date
K

Kali

Hi. Hope someone can help me with this.
I have this vlookup, where I want the cell to display a zero, if not found,
but instead I am getting #N/A. I tried putting 0, instead of False, but that
didn't work.

=VLOOKUP(W15,Data!A:G,7,FALSE)
 
Hi.  Hope someone can help me with this.  
I have this vlookup, where I want the cell to display a zero, if not found,
but instead I am getting #N/A.  I tried putting 0, instead of False, but that
didn't work.

=VLOOKUP(W15,Data!A:G,7,FALSE)
Click to expand...

This forum is for Acces not Excel however here is the answer:


=IF(ISNA(VLOOKUP(W15,Data!A:G,7,FALSE))),0,VLOOKUP(W15,Data!A:G,
7,FALSE))

Ron
 
Sorry, but this newsgroup is for questions about Access, the database
product that's part of Office Professional.

You'd be best off reposting your question to a newsgroup related to Excel.
 
Back
Top