using a reference in vlookup with excel 2003

  • Thread starter Thread starter Don O
  • Start date Start date
D

Don O

My formula, =vlookup(223995,a2:g19,5,false) works fine
My formula, =vlookup(j4,a2:g19,5,false) doesn't work. J4 is the
reference to the cell containing the number 223995. The return is #N/A

In excel 2000 this was not a problem.
Thanks in advance for your help.
Don
Durham, NC USA
 
Hi!

Is J4 formatted as text?

Are there possibly leading or trailing spaces in J4?

Biff
 
Don

Mayhaps the 223995 in J4 has an extra space before or after.

Try clearing J4 and re-typing the number.

Gord Dibben Excel MVP
 
You must log in or register to reply here.

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

Similar Threads

Wrong Result with an IF function 6
IF AND VLOOKUP formula needed 1
Vlookup to reference offset 1
EXCEL - IF(IFERROR(VLOOKUP question 0
Use & with two formulas 2
Excel Vlookup Help 0
VLOOKUP 6
Referring to a cell by using another cell for the row number 6

Back
Top