Hi guys, Welcome to the Advanced Video Search Engine, and you are watching Lookup the Last Matching Value. That video is uploaded by Doug H at 2017-06-28T06:00:24-07:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [srpqosbYhuc]
| Name | Lookup the Last Matching Value |
| Video Uploader | Video From Doug H |
| Upload Date | This Video Uploaded At 28-06-2017 13:00:24 |
| Video Discription | If you are familiar with lookup function in Excel, it brings back the first value it finds in your lookup table. What if you had multiple values but wanted to find the last (or maybe it is the most current) value from your table? You could do some table sorting (like sort descending on some criteria like date) and then let the lookup function do it or use can use an "older" lookup function in Excel aptly named LOOKUP to do this for you. You do need to perform some calculation first and then have it wrapped in the lookup function. It's actually not that hard so check out the video. ๐ SUBSCRIBE to my channel โ https://goo.gl/wN3c3p ๐ซ Excel Training โ https://www.exceltraining101.com/p/training.html ๐ 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" https://www.youtube.com/watch?v=COUOvhbQ4CQ -~-~~-~~~-~~-~- srpqosbYhuc |
| Category | Education |
| Tags | last | tip | item | vlookup | occurence | column | index | retrieve | matching | match | excel 2013 | msoffice | excel youtube channel | get last | microsoft | training | 101 | learn excel | tutorial | returen | lookup | doug | duplicate | dough | easy | simple | power query |
