Forum Discussion

andivogli's avatar
andivogli
Copper Contributor
Nov 06, 2025

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...
excel
m_tarler's avatar
m_tarler
Bronze Contributor
Nov 07, 2025

alternatively you can try:

=VLOOKUP(TEXT(B2,"0000"),'[file B analysis.xlsx]Same G diff Code same Name 32'!$B$2:$F$33,5,false)

BTW if you have excel 365 then yuo might want to consider updating to using XLOOKUP

Resources