VLOOKUP not working due different formats in lookup data & table?

[Guest]

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?

 

[Guest]

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.

 

[Guest]

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