dynamic

Excel Dynamic Reference Sheet Name. This is a dynamic cell reference example. Where b3 is the example of yours.

We will input the following values into cell a1 in sheet1, sheet2, sheet3, and sheet4 respectively: I am currently trying to write a index match formula that would have a dynamic reference linked to the sheet name i pick from a drop down. I have attached the example file.