I need VBA or excel formula to loop through table and copy paste values while 2 other values are met

mpatino

Board Regular
Joined
Jul 8, 2009
Messages
82
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.
 

Attachments

  • Table 1.png
    Table 1.png
    9.9 KB · Views: 6
  • Table 2 and 3.png
    Table 2 and 3.png
    13.1 KB · Views: 7

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

Forum statistics

Threads
1,140,933
Messages
5,703,239
Members
421,287
Latest member
Ravi bhatia

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top