Forum Discussion
Vlook up issue related to format of cells between two different files
I want to apply the vlook formula for working purposes, the issue is : I have two files file A Nace codes file B analysis There are 616 rows in file A nace codes while in file B there are 32...
I suspect that your 'tiger codes' in file B are texts whereas the 'name codes' in file A are numbers. Simply formatting both columns as Number does not change a text to a number or vice versa. VLOOKUP will thus not find a match and always return #N/A.
Probably easiest to transform column B in file A to text with Text-To-Columns. You find the icon on the Data ribbon.
Save you file before doing this so that you can always revert back it in case it doesn't work as expected!
Select B2:B616, Text to columns, step1 change nothing, next, step 2 change nothing, next, step 3 set the column data format to Text, Finish.
Now the name codes in file A are all texts and VLOOKUP should be able to find matching codes from file B.