Forum Discussion
How to relate a variable cell's value to a particular worksheet?
=INDIRECT("Sheet"&D1&"!A1")
In D1 enter sheet number and value of Sheet1 cell A1 or Sheet2 cell A1.... is retrieved. In my attached example 17 is in cell A1 of Sheet1.
=INDIRECT("Sheet"&D1&"!A1")
In D1 enter sheet number and value of Sheet1 cell A1 or Sheet2 cell A1.... is retrieved. In my attached example 17 is in cell A1 of Sheet1.
Thanks for the quick respond & very much appreciated. I have attached the example in my attachment jpeg file where in diagram 1, user will input value in month, day & store #, in order to retrieve total qty value from that particular month worksheet (diagram 2). In this case, I know how to apply functions like index & match but how to integrate this INDIRECT function into index & match functions? Please advice. Thank you very much.
=INDEX(INDIRECT("'"&C2&"'!C2:F5"),MATCH(C4,INDIRECT("'"&C2&"'!A2:A5"),0),MATCH(C3,INDIRECT("'"&C2&"'!C1:F1"),0))
Is this what you are looking for?
- Yes. you are great, thanks for solving my missing puzzle.