MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Charlie Rogers on August 29, 2001 7:50 AM

I have 2 files from different sources; I need to do a V-LOOKUP on these files. The problem is that they are both formatted differently, I can't get the V-LOOKUP to work with these different formats. I tried highlighting the spreadsheet and changing the format to either (TEXT or General) with no luck. These spreadsheets contain both alphabetical and numerical data.

Posted by Eric on August 29, 2001 8:33 AM

Could you post a sample of what the data?
Also, have you tried copying from one sheet and "paste special" "format" to the other sheet.
Also, if your vlookup is set to "false" are you absolutely certain that the two match? Have you checked len() to see if they are the same length at least?
Just some ideas

Posted by Don on August 29, 2001 2:23 PM

Eric is right that cells that look the same may not be.

- You can do some problem solving such as:
checking the length of two cells that you want to match to be sure the number of characters is the same -
- watch for non-printing characters
e.g. =vlookup((Clean(A1)...
or = vlookup((trim(A1)...

Also characters that look like numbers may not be

In short do some manual checking that the cells really are the same.