Nov 12 2021 01:28 PM
I'm lost. I need some expert help figuring out two formulas (see sample data attached). The data is in the blue and yellow cells. The results are in the orange cells. If someone responds I will explain what I need.
I'm on a PC using Windows 10. Thx.
Nov 12 2021 01:40 PM
=INDEX($A$5:$A$12,MATCH(1,(A18>=$B$5:$B$12)*(A18<=$C$5:$C$12),0))
=INDEX($D$5:$F$12,INDEX($A$5:$A$12,MATCH(1,(A18>=$B$5:$B$12)*(A18<=$C$5:$C$12),0)),MATCH(B18,$D$4:$F$4,0))
Are these the formulas you are looking for? I have to enter these formulas with ctrl+shift+enter as i don't work with Office365 or 2021.
Nov 12 2021 02:00 PM
=FILTER($A$5:$A$12,($B$5:$B$12<=A18)*($C$5:$C$12>=A18))
=INDEX($D$5:$F$12,C18,MATCH(B18,$D$4:$F$4,0))
Nov 12 2021 03:13 PM