IndexMatch formula based on name of Excel Sheet

[Jyggalag]

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!

 

[Fluff]

How about

=INDEX(indirect("'"&N651&"'!$V$3:$V$73"),MATCH(1, (indirect("'"&N651&"'!$B$3:$B$73")=$D651)*(indirect("'"&N651&"'!$A$3:$A$73")=$N651),0))

 

[Jyggalag]

How about

=INDEX(indirect("'"&N651&"'!$V$3:$V$73"),MATCH(1, (indirect("'"&N651&"'!$B$3:$B$73")=$D651)*(indirect("'"&N651&"'!$A$3:$A$73")=$N651),0))

You're amazing Fluff. And inhumanly fast!

Thank you so much, once again!

Kindest regards,

Jyggalag

 

[Fluff]

You're welcome & thanks for the feedback.