Forum Discussion
Artasylum
May 17, 2022Copper Contributor
Need assistance / help determining formula / IF function?
Hello everyone! I'm wholly unfamiliar with the possibilities Excel can provide, so I need help automating an effect I'd like to happen. For my life, I cannot find a similar situation online so I ...
OliverScheurich
May 17, 2022Gold Contributor
=INDEX($B$2:$F$6,MATCH(A10,$A$2:$A$6,0),MATCH(B10,$B$7:$F$7,0))
An alternative could be this formula with the layout of the attached file.