Hi guys,
I have 2 tables and I need to fill a 3rd table comparing the values from table 2 with table 1 and copying pasting the values into 3 while the conditions are met. For example, from the uploaded images, in table 1, there are different header names in the range A1:L1 and different values beneath these headers, in table 2, I have two columns, Item and Combo_id, so, I need to compare the item from this table with the column L and the Combo_id with the rest of the columns in table 1, and return all the attributes names from column A and all the values beneath the header matching the Combo_Id as shown in table 3 from the image.
Is this possible with VBA or a formula?
Appreciate all your assistance.
I have 2 tables and I need to fill a 3rd table comparing the values from table 2 with table 1 and copying pasting the values into 3 while the conditions are met. For example, from the uploaded images, in table 1, there are different header names in the range A1:L1 and different values beneath these headers, in table 2, I have two columns, Item and Combo_id, so, I need to compare the item from this table with the column L and the Combo_id with the rest of the columns in table 1, and return all the attributes names from column A and all the values beneath the header matching the Combo_Id as shown in table 3 from the image.
Is this possible with VBA or a formula?
Appreciate all your assistance.