Cell formatting using VLOOKUP

[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

 

[Frank Kabel]

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

 

[xlbo]

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