#REF errrors using vlookup

J

Jim Berglund

I'm getting #REF errors when using the vlookup function. It happens
everywhere! All of a sudden, vlookup just won't work.

Specifically, in cell Q2, I used =vlookup(P2,$A$2:$A$1000,2) and got #REF.
The value in P2 is the same as the value in A2.

Does anyone have any idea what I can do to fix it?

Thanks,
Jim Berglund
 

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

VLookup Won't Copy down (#REF! error) 1
Using vlookup to populate multiple rows at once 6
VLOOKUP & Data Validation 0
Error message #REF! with Vlookup function 0
Using Parsed String Results in VLOOKUP 2
Vlookup and Indirect help!! 2
Help with Vlookup and MAX functions 4
#REF! error with Multiple Documents 7

Top