Forum Discussion
Index/Match/OR Formula
Hi, Looking for assistance if possible: Data Table Year 22 Year 23 Year 24 Year 25 Year 26 Year 27 LEV A 1 1,000 1,046 1,083 1,116 1,151 1,186 LEV A 2 2,000 2,092 2,1...
=INDEX($C$2:$H$4,MATCH(1,($A$2:$A$4=$K$6)*($B$2:$B$4=K7),0),MATCH($K$5,$C$1:$H$1,0))You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or Excel 2021.
Many thanks, OliverScheurich; that looks to do the trick; such subtle changes to the formula 🙂
I tried using C:H but dot not swap the matches around etc.
Much appreciated
I tried using C:H but dot not swap the matches around etc.
Much appreciated