Hi,
I hope someone can help me with this since I really can't seem to get it right.
I have two excel files in the same folder. Both of them contain customer numbers and one also some additional information to this number. I want to first see if the customer number exist in the other file and if so add the infoo from that row in the other file.
To clarify:
Excelfile 1: Have Customernr.
Excelfile 2:Have Customernr + four columns with info in stringform, i.e can be both text and numbers.
If the numbers match i want to add in Excelfile 1 the info from the four cells from the four columns from Excelfile 2 next to the Customer number.
I tried to use: =INDEX([test.xlsx]Blad1!$B$2:$B$569;MATCH(G2;[test.xlsx]Blad1!$A$2:$A$569;0); 2) and then my idea was to repeat this formula four times to recieve one row. However this does not work.
Have anyone an idea what could work?
I would be forever grateful!
I hope someone can help me with this since I really can't seem to get it right.
I have two excel files in the same folder. Both of them contain customer numbers and one also some additional information to this number. I want to first see if the customer number exist in the other file and if so add the infoo from that row in the other file.
To clarify:
Excelfile 1: Have Customernr.
Excelfile 2:Have Customernr + four columns with info in stringform, i.e can be both text and numbers.
If the numbers match i want to add in Excelfile 1 the info from the four cells from the four columns from Excelfile 2 next to the Customer number.
I tried to use: =INDEX([test.xlsx]Blad1!$B$2:$B$569;MATCH(G2;[test.xlsx]Blad1!$A$2:$A$569;0); 2) and then my idea was to repeat this formula four times to recieve one row. However this does not work.
Have anyone an idea what could work?
I would be forever grateful!