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 ➜ goo.gl/wN3c3p
🏫 Excel Training ➜ www.exceltrain...
📚 Excel Books & Tech Gear ➜ www.amazon.com...
⚙️ Tools: Screencasting ➜ techsmith.z6rj...
⚙️ Tools: Microsoft Office ➜ microsoft.msaf...
⚙️ Tools: TubeBuddy ➜ www.tubebuddy....
📝 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 www.buymeacoff...
#excel
#msexcel
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF...
~-~~-~~~-~~-~
Негізгі бет Lookup the Last Matching Value
Пікірлер: 82