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