How to use XLOOKUP for Reverse Order Search

Video Description

Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/ Learn how to use XLOOKUP to search in reverse order last-to-first or bottom-to-top. This allows us to find the most recent occurrence of entry and return a matching value from another column or row. We also look at how to create a running total reference in our formula to the only search in the rows above the formula. I explain how to create this reference with the structured references (table formulas) using the INDEX function. This is Part 2 of 6 in a series that shows you how to build a dashboard for an attendance report. This dashboard was originally submitted as an entry in the Excel Hash competition: https://youtu.be/FmHBpkscsZA If you’d like to see the accompanying blog post on my website, you can find it at this link: https://www.excelcampus.com/functions/xlookup-reverse-order-search/ Additional Resources: Part 1 of 6: How to use the XOR Function: https://youtu.be/oe8oOmVRKOg Excel Hash: Attendance Report with Storm Clouds & Fireworks: https://www.youtube.com/watch?v=FmHBpkscsZA&t=30s XLOOKUP Explained: https://youtu.be/txK0C6SkaMg #MsExcel #ExcelCampus 00:00 Introduction 00:39 Using XLOOKUP 02:35 Running Total References 07:43 Running Totals with Structured References