Hi All!
My google searches are coming up empty, so I'm not sure if this is even possible.
I'm trying to do a simple Index/match to grab data from another sheet, but with an added twist of instead of hard typing in the range it's pulling data from, it gets the range from another cell on a separate tab.
This is what the normal code looks like:
=INDEX('MTD Shrink'!J7:J29,MATCH(Main!AG7,'MTD Shrink'!A7:A29,0))
Here is what I want it to do:
=INDEX('MTD Shrink'!('Data Location'!O13),MATCH(Main!AG7,'MTD Shrink'!A7:A29,0))
So instead of typing in the range J7:29, it's looking in the data location tab, in Cell O13, which has J7:J29 in it.
Is this possible to do, either using index match or another formula?
Thanks so much all!
My google searches are coming up empty, so I'm not sure if this is even possible.
I'm trying to do a simple Index/match to grab data from another sheet, but with an added twist of instead of hard typing in the range it's pulling data from, it gets the range from another cell on a separate tab.
This is what the normal code looks like:
=INDEX('MTD Shrink'!J7:J29,MATCH(Main!AG7,'MTD Shrink'!A7:A29,0))
Here is what I want it to do:
=INDEX('MTD Shrink'!('Data Location'!O13),MATCH(Main!AG7,'MTD Shrink'!A7:A29,0))
So instead of typing in the range J7:29, it's looking in the data location tab, in Cell O13, which has J7:J29 in it.
Is this possible to do, either using index match or another formula?
Thanks so much all!