Forum Discussion
Solved
Simpler Formula
Hi,
Looking for a simpler formula as explained in the attachment.
=INDEX($C$3:$C$7,MATCH(1,(E2>=$A$3:$A$7)*(E2<=$B$3:$B$7),0))An alternative could be this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.
=INDEX($C$3:$C$7,MATCH(1,(E2>=$A$3:$A$7)*(E2<=$B$3:$B$7),0))An alternative could be this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.
- thank you !
