New Contributor

# 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 explain what I need.

I'm on a PC using Windows 10. Thx.

3 Replies

# Re: Need help figuring out 2 formulas

=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.

# Re: Need help figuring out 2 formulas

``````=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))``````

# Re: Need help figuring out 2 formulas

Don’t know. I’ll check it out. Thanks for the reply.