Lookup the Most Recent Past Date Based on Criteria - Excel Formula

In this video, we use an Excel formula to lookup the most recent date in the past based on criteria. Our example is to return the date of the most recent class, specified by a cell value. This is an intriguing challenge which came about from a question on one of my other videos. It utilises a couple of helper columns with formulas before we use an INDEX and MATCH formula combination to return the date. Find more great free tutorials at; https://www.computergaga.com *** Online Excel Courses *** The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel Excel VBA for Beginners ► http://bit.ly/2JvnnRv Advanced Excel Tricks ► https://bit.ly/3CGCm3M Excel Formulas Made Easy ► http://bit.ly/2t3netw Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2viGg3J Connect with us! LinkedIn ► https://www.linkedin.com/company/18737946/