Problems with HLOOKUP and VLOOKUP

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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,...)?
 
Back
Top