Combining INDIRECT with INDEXMATCH

surkdidat · Dec 7, 2017

Hi there, I have the following indexmatch formula, but I want it to include an INDIRECT (if poss)

Code:

=INDEX('Standard'!A2:M16,MATCH(C5,'Standard'!A2:A16,FALSE),M10)

What I need to do is for the sheet called standard,to reference the contents of c9 to establish which sheet to look up on please

Many thanks

FormR · Dec 7, 2017

Hi, you could try like this:

=INDEX(INDIRECT("'"&C9&"'!A2:M16"),MATCH(C5,INDIRECT("'"&C9&"'!A2:A16"),0),M10)