Forum

Notifications
Clear all

row and column match across multiple worksheets

4 Posts
3 Users
0 Reactions
127 Views
(@kpmsivaprakasam2003)
Posts: 15
Eminent Member
Topic starter
 

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

 
Posted : 27/09/2020 1:30 am
Philip Treacy
(@philipt)
Posts: 1632
Member Admin
 

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

 
Posted : 27/09/2020 3:11 am
Anders Sehlstedt
(@sehlsan)
Posts: 974
Prominent Member
 

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

 
Posted : 27/09/2020 3:16 am
(@kpmsivaprakasam2003)
Posts: 15
Eminent Member
Topic starter
 

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

 
Posted : 01/10/2020 9:47 am
Share: