Forum Discussion
Need help figuring out 2 formulas
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 expla...
=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))