text / format issues

Hi Leechy,

The space before your lookup table values is not a regular space character (code 32), it is a non-breaking space (code 160). You have a couple options:

1. Edit each of those cells and delete the first character manually;

2. Create a second column for your lookup table and use the following formula to extract all but the non-breaking space character, then lookup on that column with a VLOOKUP formula:
=RIGHT(A4,LEN(A4)-1)

3. Don't create a second column, and use the following formula to check your lookup value against an array of the lookup values minus their non-breaking space (note, this is an array formula confirmed with CTRL+SHIFT+ENTER, not just ENTER):
=INDEX(C4:C6,MATCH(TEXT(A14,"@"),RIGHT(A4:A6,LEN(A4:A6)-1),0))

4. Use a macro to remove all the non-breaking spaces and then use a normal VLOOKUP.

I hope that helps you along..