Problems with HLOOKUP and VLOOKUP

F

Frank

The letters A, B and C [also word starting with letters A, B, and C] do not
lookup and give an N/A message BUT all the other letters from D to Z works
fine. Any word works fine and lookup fine, exept those starting with the
first three letter of the alphabet; for example ,Conor do not work but Dubai
works, Apple do not work but Zulu works, Bee do not work but Fly works, etc.

Tahnk you for the help
 
M

Max

To increase chances of better responses flowing in here, post samples of your
actual formulas. It could be a data consistency problem too, between the
lookup values and the table array's lookup col values. What happens when you
wrap a TRIM around your lookup values, eg: VLOOKUP(TRIM(A1),....) instead of
VLOOKUP(A1,...)?
 
Top