Compare headings in row, where match bring content.

[Mldeuser]

Hello

I have two spreadsheets in the same workbook, I need to pull information from each into a third worksheet. The worksheets are labeled ASV, IAR, Combined.

The two worksheets have alot of columns (not necessarily the same columns). The number of rows vary between the two

Is it possible to match the heading from the Combined tab to the other two worksheets and when there is a match bring back the information in the cells from the ASV & IAR tab into the column on the Combined tab.

Finding the headings and using the copy paste function would be time consuming.

Thank you

 

[Mldeuser]

Never mind, I figured it out.

Thank you