If the cell number is text (which is usually the case) and you are using
Excel 2003, when you select the cell with a "text" number you will see a
little warning box to the left if you click on it one of the options is
convert to number, do that and the lookup should work.

If you are using an older version of excel you can convert the cell using
the =value( ) function



"MikeNeilWalker" wrote:

I think it is a formatting problem but not certain on this. How do I make
the lookup data and the column in the table array the same format so the
lookup works?