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
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