Hi,
I am using Excel 2013
I need consolidate from A1 Sheet to A16 Sheet.....etc....
The Data is available from the A1 sheet to .....
In "A1" Sheet Details is Range(A2:A9) Row Number, Range(B1:O1) Column Number, and Range(B2:O9) Data details and below here
| A | B | C | D | |
| 1 | A1 | 1 | 2 | 3 |
| 2 | 8 | |||
| 3 | 7 | |||
| 4 | 6 | JOLLY TRAIN 21-02-2020 24 | JOLLY TRAIN 21-02-2020 24 |
I put in the "Summary" sheet below the heading
In "Summary" Sheet is A Column is Sheet Name, B Column is Row Number, C Column is Column Number, and D Column is Formula Requirement
D1 Cell is Row No 8 match in A1 Sheet "A Column" and Column No 1 match in A1 Sheet "1 Row"
I can try in index+match+match formula, but no results
| A | B | C | D | |
| Sheet Name | Row No | Column No | Formula Requirement | |
| 1 | A1 | 8 | 1 | |
| 2 | A1 | 8 | 2 | |
| 3 | A1 | 8 | 3 | |
| 4 | A1 | 8 | 4 | |
| 5 | A1 | 8 | 5 | |
| 6 | A1 | 8 | 6 |
Thanks and Help for the advance formula
Hi,
https://www.myonlinetraininghub.com/excel-forum/forum-rules-and-guides/read-this-first
Please provide a workbook containing your data and example(s) of the expected result.
Phil
Hello,
I would like to help, as also many others in this forum. But as there is no sample file attached I don't see how I can help you out.
Br,
Anders
Hi,
Sorry for not attachment, now attached. But I found one method formula in the "Summary" sheet.
But Thank you for your support
In case alternate available that formula, please provide the formula
