Jyggalag
Active Member
- Joined
- Mar 8, 2021
- Messages
- 445
- Office Version
- 365
- 2019
- Platform
- Windows
Hi all,
I currently have this setup:
Formula in full: INDEX('Q4'!$V$3:$V$73,MATCH(1, ('Q4'!$B$3:$B$73=List!$D651)*('Q4'!$A$3:$A$73=List!$N651),0))
My sheet used to be simply called "Sheet1". However, I have renamed it "Q4" now.
I want my formula to pull in data based on the value in column N. Right now, in the example above, the cell N651 has the value "Q4". I want the formula to pull in this information and based on that get the results from the sheet "Q4".
It used to work before, however, that was before i wanted it to be reliant on the sheet name.
Can somebody please help me update my formula so it works like this?
I hope that what I am asking makes sense. If not, please feel free to ask me for an elaboration!
Thank you all!
I currently have this setup:
Formula in full: INDEX('Q4'!$V$3:$V$73,MATCH(1, ('Q4'!$B$3:$B$73=List!$D651)*('Q4'!$A$3:$A$73=List!$N651),0))
My sheet used to be simply called "Sheet1". However, I have renamed it "Q4" now.
I want my formula to pull in data based on the value in column N. Right now, in the example above, the cell N651 has the value "Q4". I want the formula to pull in this information and based on that get the results from the sheet "Q4".
It used to work before, however, that was before i wanted it to be reliant on the sheet name.
Can somebody please help me update my formula so it works like this?
I hope that what I am asking makes sense. If not, please feel free to ask me for an elaboration!
Thank you all!