Excel Lookup to Return the Last Value
Usually when you're doing lookups in Excel, it brings back the first value that matches. But what if you want the last value and did not want to sort the table to do that? You can actually perform this type of lookup quite easily in Office 365 version of Excel with the XLOOKUP function. But what if you don't have O365? Well you're not stuck, cause you can combine some functions (INDEX, LARGE, IF and ROW) to do the same thing. I'll show examples of both and offer a bonus on how to create a drop down list near the end.
🔔 SUBSCRIBE to my channel ➜ https://goo.gl/wN3c3p
🏫 Excel Training ➜ https://www.exceltraining101.com/p/tr...
📚 Excel Books & Tech Gear ➜ https://www.amazon.com/shop/dough
⚙️ Tools: Screencasting ➜ https://techsmith.z6rjha.net/5Qe53
⚙️ Tools: Microsoft Office ➜ https://microsoft.msafflnk.net/rKL0G
⚙️ Tools: TubeBuddy ➜ https://www.tubebuddy.com/et101
📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!
🎁 If you find these videos useful and want to support my channel go to https://www.buymeacoffee.com/dough
#excel
#msexcel
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF File to Excel
~-~~-~~~-~~-~