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.
Hi ikedalim,
You would need INDIRECT function to refer it to sheet, please share sample workbook if need further support
Regards, Faraz Shaikh | Microsoft MVP, MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official/Best Answer & like it to help the other members find it more.
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.