The format wont stop lookup from working. Usually the problem is either the
cell is text and the formula is looking for a number or the reverse is
happening.

Look for double quotes " in either the formula or the cell. Second
possiblity is there is spaces in the formula or the cell.

To check for spaces in the cell you can use =len(A6). Make sure there isn't
any spaces.

"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?