Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
SOLVED

Excel formulas

Copper Contributor

Hi everyone :)

 

I have two different tables with different informations. 
on the first one are article numbers with total sold pieces.

in the other table are article numbers with their system information.

The two tables can have articles that are not in both tables.

how can I add to the first table the system information, so that every article number has the right system belonging information?

 

many thanks in advance

 

 

5 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

@Artangraz - Did you try with the Vlookup?

 

SanthoshKunder_0-1695734618434.png

 

@SanthoshKunder Hi there! Thank you very much for your reply. how can I translate this in German?Could you give me the formula in german?.

 

many thanks in advance :)

@Artangraz 

Just in case, you may use this tool Translator • Excel-Translator to translate formulae.

I just turned my excel to English. Thanks very much
Thank you very much. This is eventually very helpful
1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution

@Artangraz - Did you try with the Vlookup?

 

SanthoshKunder_0-1695734618434.png

 

View solution in original post