Forum Discussion
Solved
IF THEN formula help with multiple criteria (selections)
Hello! I need support in creating a formula(s) that satisfy these requirements: Current Layout: Store Manager Name Overall Performance (Can only be Red, Green, Yellow) Career Mobilit...
I'd create a two-dimensional lookup range:
Here it's on the same sheet, but it can be on another sheet, even a hidden one.
The formula in D2 can then be
=INDEX($I$3:$K$5,MATCH(B2,$H$3:$H$5,0),MATCH(C2,$I$2:$K$2,0))
I'd create a two-dimensional lookup range:
Here it's on the same sheet, but it can be on another sheet, even a hidden one.
The formula in D2 can then be
=INDEX($I$3:$K$5,MATCH(B2,$H$3:$H$5,0),MATCH(C2,$I$2:$K$2,0))
Thank you so much! I am not great at INDEX formulas so that was a little tricky, but did the job and made it wayyyy easier than me creating a million formulas.