Merge 2 unequal excel files

[InfinityMrsn]

I extract data from a system and those numbers need to be processed into an order sheet of our customer.

I was hoping someone can help me with a formula to simplify and speed this up. Now I fill the ordersheet piece by piece, but the number of different products grows enormously so this takes a lot of time.

Additional information:
- The article numbers are not on equal lines and some article numbers do not appear.


Please find attached 2 screenshots. I would like the numbers of the yellow cells (file 1) to be filled in the green cells (file 2).

 

[Fluff]

You can use the XLOOKUP function for that. XLOOKUP Function

 

[InfinityMrsn]

Thanks Fluff. I found a start, but i'm not sure how to finish this formula

=VERT.ZOEKEN(A2;'[Kopie van total price of 25.8.2023-SS.xlsx]Blad1'!$B$2:$E$16;

The values in column A are compared, but the value of column 5 must be adopted.

 

[Fluff]

That is not Xlookup, it looks more like Vlookup.

 

[InfinityMrsn]

Thanks for your answer. i will try looking for the right formula.

 

[Fluff]

Something like

=X.ZOEKEN(A2;[Kopie van total price of 25.8.2023-SS.xlsx]Blad1'!$B$2:$B$16;[Kopie van total price of 25.8.2023-SS.xlsx]Blad1'!$E$2:$E$16)

 

[InfinityMrsn]

Thanks, found it

=X.ZOEKEN(A2;'[Kopie van total price of 25.8.2023-SS.xlsx]Blad1'!$B$2:$B$16;'[Kopie van total price of 25.8.2023-SS.xlsx]Blad1'!$E$2:$E$16)

 

[Fluff]

You're welcome & thanks for the feedback.