Forum Discussion
John23785
Mar 11, 2024Copper Contributor
Formula Help - IF/OR/AND
Hello - I am trying to work through a formula for a much larger dataset and I've created an example which I will attach to this discussion post. Basically, I want to create a formula where if the "Gr...
- Mar 11, 2024
Formula in cell N4 and filled down:
=INDEX($D$10:$D$15,MATCH(1,(J4>$B$10:$B$15)*(J4<=$C$10:$C$15),0))
Formula in cell O4 and filled down:
=INDEX($D$10:$D$15,MATCH(1,(K4>$E$10:$E$15)*(K4<=$F$10:$F$15),0))
You can try these formulas. Enter the formulas with ctrl+shift+enter if you don't work with Office 365 or Excel for the web or Excel 2021.
John23785
Copper Contributor
OliverScheurich
Mar 11, 2024Gold Contributor
Formula in cell N4 and filled down:
=INDEX($D$10:$D$15,MATCH(1,(J4>$B$10:$B$15)*(J4<=$C$10:$C$15),0))
Formula in cell O4 and filled down:
=INDEX($D$10:$D$15,MATCH(1,(K4>$E$10:$E$15)*(K4<=$F$10:$F$15),0))
You can try these formulas. Enter the formulas with ctrl+shift+enter if you don't work with Office 365 or Excel for the web or Excel 2021.