vlookup help

G

Guest

I am using vlookup, which returns #N/A error. I have searched most Q/A's and understand when this error is returned. I know that the error is being returned as a result of the lookup value this it is using on the worksheet. The part I do not understand is that if I delete the value in the cell that is the reference to lookup value and then retype the exact same value, the formula works. Anyone have an idea of the cause?? I have already checked the cell format on both lookup value and table array and they are consistent

Please help
 
G

Guest

-----Original Message-----
I am using vlookup, which returns #N/A error. I have
searched most Q/A's and understand when this error is
returned. I know that the error is being returned as a
result of the lookup value this it is using on the
worksheet. The part I do not understand is that if I
delete the value in the cell that is the reference to
lookup value and then retype the exact same value, the
formula works. Anyone have an idea of the cause?? I
have already checked the cell format on both lookup value
and table array and they are consistent.
 
C

Charlie

The problm might be extra spaces in the table containg the
lookup value. Even trailing space can cause this error,
by retyping the value you are deleting those trailing
space. Perhaps try using the 'Trim' function to remove
and unwanted spaces in your table.

Charlie O'Neill
-----Original Message-----
I am using vlookup, which returns #N/A error. I have
searched most Q/A's and understand when this error is
returned. I know that the error is being returned as a
result of the lookup value this it is using on the
worksheet. The part I do not understand is that if I
delete the value in the cell that is the reference to
lookup value and then retype the exact same value, the
formula works. Anyone have an idea of the cause?? I
have already checked the cell format on both lookup value
and table array and they are consistent.
 
G

Guest

-----Original Message-----
I am using vlookup, which returns #N/A error. I have
searched most Q/A's and understand when this error is
returned. I know that the error is being returned as a
result of the lookup value this it is using on the
worksheet. The part I do not understand is that if I
delete the value in the cell that is the reference to
lookup value and then retype the exact same value, the
formula works. Anyone have an idea of the cause?? I
have already checked the cell format on both lookup value
and table array and they are consistent.
 
G

Guest

In my experience the cell formatting has to be consistent
BEFORE the Vlookup formula is created.

I cannot guarantee that this is the solution but it's
worth a try
-----Original Message-----
I am using vlookup, which returns #N/A error. I have
searched most Q/A's and understand when this error is
returned. I know that the error is being returned as a
result of the lookup value this it is using on the
worksheet. The part I do not understand is that if I
delete the value in the cell that is the reference to
lookup value and then retype the exact same value, the
formula works. Anyone have an idea of the cause?? I
have already checked the cell format on both lookup value
and table array and they are consistent.
 

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 with#N/A 1
Vlookup Function 1
Excel Trying to do a vlookup with a nested right function on the array 3
VLookup 1
Vlookup error 5
LOOKUP does not work with MID when a number 4
error #N/A 8
VLOOKUP 2

Top