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,...)?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Frank" wrote:
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, except 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.

Thank you for the help