Cell formatting using VLOOKUP

  • Thread starter Thread starter chainsaw
  • Start date Start date
C

chainsaw

When using VLOOKUP I am having some trouble with the cell that has th
lookup value. I name my range for the table array and then when
select a lookup value that I know is in the array it always comes bac
as "N/A". (I am using FALSE as the logical)

Yet when I go back into the cell that has the lookup value and retyp
exactly what was in the cell, it comes back with the result that i
needed.

Is there something about the formatting? I am using the same font
size, etc.. that is in the array.

Any clue would help.

Thanks
 
Hi
looks like there are some other characters in your range (Spaces,
special characters, etc.). You may test the following:
=lookup_cell=cell_in_your_range
compare your lookup criteria directly with a cell that should match
(that is the above should return TRUE)

Frank
 
It is usually either spaces or "Textual numbers" that cause this issu

If all the lookups are text based (no numbers involved), you should tr
If original formula i
=vlookup(A1,D1:M1000,3,false
new formula could b
=vlookup(trim(A1),D1:M1000,3,false

If you are looking up numbers than you will need to convert one side or the other - here are some options to try
=vlookup(Text("A1,"0"),D1:M1000,3,false) - will look up a number into a "Textual number" fiel
=vlookup(Value(A1),D1:M1000,3,false) - will look up a "Textual number" into a number fiel

Geof
 
Back
Top