Problems with HLOOKUP and VLOOKUP

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
 
G

Guest

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

Problems with HLOOKUP and VLOOKUP 1
Scrabble Value calculation for Welsh words 0
Vlookup and Hlookup with an IF condition 0
Vlookup combined with Hlookup 7
Vlookup and Hlookup Combine? 1
Combining Hlookup and vlookup 6
vlookup and hlookup 4
How do I use case sensitive VLOOKUP? 8

Top