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

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

Scrabble Value calculation for Welsh words 0
Problems with HLOOKUP and VLOOKUP 1
Vlookup/Hlookup confusion 1
Vlookup and Hlookup with an IF condition 0
Index / Hlookup 1
Help With VLOOKUP 2
vLookup 5
Excel Convert word into numbers and back 4

Back
Top