Try this formula in cell W4:
=IF(V3=V4,INDEX(INDIRECT("I"&MATCH(W3,I:I,0)+1&":I26"),MATCH(V4,INDIRECT("R"&MATCH(W3,I:I,0)+1&":R26"),0)),INDEX($I$2:$I$26,MATCH(V4,$R$2:$R$26,0)))
The calculation ...READ MORE
Oct 8, 2022
in Others
by
narikkadan
• 63,680 points
•
943 views