Most times what you think are the correct values have an extra space or two, so
they are not correct.

Try the TRIM function to get rid of any extra spaces.

If still needing help, post your formula and a small sample of data range from
worksheet2


Gord Dibben MS Excel MVP

On Tue, 6 Feb 2007 15:38:00 -0800, trainer07
wrote:

When I write a vlookup formula, I receive an #NA error even though the values
to be looked up are found in the lookup table on Worksheet 2. Any ideas?