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.
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.