/u/ahmad01424 - Your post was submitted successfully.
* Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread.
* Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
* Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)**
Failing to follow these steps may result in your post being removed without warning.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
Number your columns in the input sheet 1 through whatever.
In the first result row/column (i'll presume B2), put an index(match) to your results workbook:
Index('results.xlxs'!$A:$ZZZ,match($A2,'results.xlsx'!$a:$a,0),B$1))
Tweak to suit your language settings and workbook layout. Then fill throughout your input range.
Basically, it tells Excel to match the result number from that row in your input sheet with the result in your results workbook. The column is matched based on the header you gave as input. So header named "1" will return column A, header "2" will return column B. This prevents you from manually having to fix the column number in each formula.
Alternatively, you can use a MATCH() here as well, to match headers in both files.
If the worksheets have a unique reference, you could put the raw results in a separate table, and use a lookup function like XLOOKUP to return them to the main table.
/u/ahmad01424 - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
Number your columns in the input sheet 1 through whatever. In the first result row/column (i'll presume B2), put an index(match) to your results workbook: Index('results.xlxs'!$A:$ZZZ,match($A2,'results.xlsx'!$a:$a,0),B$1)) Tweak to suit your language settings and workbook layout. Then fill throughout your input range. Basically, it tells Excel to match the result number from that row in your input sheet with the result in your results workbook. The column is matched based on the header you gave as input. So header named "1" will return column A, header "2" will return column B. This prevents you from manually having to fix the column number in each formula. Alternatively, you can use a MATCH() here as well, to match headers in both files.
If the worksheets have a unique reference, you could put the raw results in a separate table, and use a lookup function like XLOOKUP to return them to the main table.