Hope all is well. I am new to this forum, pleasure to meeting you all.
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.
For example in =Master!D3 there is a dropdown to pick the sheet I want the data to be pulled from at which point cell =Master!E8 and =Master!E9 autofill with the the data points from the respective sheet.
I've been banging my head all night and can't get it to work. I can get Index/Match to work off of one sheet of data but can't get it to work when referencing another dynamic sheet.
Any help would be appreciated.
Bookmarks