Forum Discussion
Solved
Excel Formula to lookup closest past date and give results
Hi there ,
Please assist me with a formula as explained in the attached file.
=INDEX($C$2:$C$6,LARGE(IF(($B$2:$B$6=G2)*($A$2:$A$6<F2),ROW($A$2:$A$6)-1),1))You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.
2 Replies
=INDEX($C$2:$C$6,LARGE(IF(($B$2:$B$6=G2)*($A$2:$A$6<F2),ROW($A$2:$A$6)-1),1))You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.
- Thank you.
