excel consulting - Formats of imported data-vlookup

Hi Martin

The only thing I can think of is even if the data looks the same visually it may be formatted in a different way as a result of being imported from another program. Or when the data is imported it is bringing in some additional characters which are causing the lookup not to recognise the data. Without seeing the spreadsheet I'm afraid I cannot be any more specific but these are things you could check/test to see if they are the root of your problem.

thanks
Amanda