srizki
Well-known Member
- Joined
- Jan 14, 2003
- Messages
- 1,860
- Office Version
- 365
- Platform
- Windows
Hi all,
In column L, I have the following formula,
=INDEX(table,MATCH(G2,INDEX(table,,1),0),MATCH(H2,INDEX(table,1,),0))
I want to add, INDIRECT to it so it can bring the number from the desired sheet, I will put the sheet name on cell G2.
How can I do it?
Thanks,
In column L, I have the following formula,
=INDEX(table,MATCH(G2,INDEX(table,,1),0),MATCH(H2,INDEX(table,1,),0))
I want to add, INDIRECT to it so it can bring the number from the desired sheet, I will put the sheet name on cell G2.
How can I do it?
Thanks,
