Workbook A contains 2 sheets. Sheet 1 contains 2 columns in C and D. Column C has names of headers while column D has the abbreviation form of the header. In sheet 2, it contains all the data formatted in columns with headers in a non abbreviated format as represented in column C.
In workbook B, it contains 1 sheet with headers but no data. All headers in workbook B are using the Column D abbreviation format.
Example of what I mean: C1 = Unique Identifier | D1 = UID
What I intend to achieve is to have a formula that:
In an empty cell below the header in workbook B, to search for the header if it is found in any of the cells under Column D of workbook A, sheet 1. If a match is found, to then match the cell in Col C to that of the headers in Sheet 2 of workbook A, and then extract out all the rows under that column into the empty cell mentioned.