finding and extracting data from Table X into Table Y

Euphoria

New member
Joined
Sep 15, 2018
Messages
1
Reaction score
0
Points
0
Excel Version(s)
Microsoft Excel 2016
Hello,

please help me figure out the right formula for the following task (please find enclosed two screenschots of the Excel worksheets):

there are two worksheets, the second workscheet, i.e. Table 2, has more information i.e. columns than the first. I have to add a column with information on weight to the first workscheet (such column is already existent in the second sheet), and use Excel to find this weight data in the second sheet based on a given order Number AND amount...so in other words, order number AND amount are two of my criteria from the first table, that are to be used to search for the weight data in the second table. This information should then be automatically added by the Excel into the first worksheet, i.e table.

Please help me, this is urgent.

Thank you.
 

Attachments

  • Unbenannt.JPG
    Unbenannt.JPG
    46.4 KB · Views: 17
  • Unbenannt2.JPG
    Unbenannt2.JPG
    52.7 KB · Views: 16
Back
Top