VLOOKUP to Find the Last Value in a List
Learn more incredible Excel Formulas - bit.ly/UltimateExcel
Use VLOOKUP to return the last match in a list. The VLOOKUP function is brilliant, but it has its limitations.
One of these is that the VLOOKUP function can only find the first value in a list. This is great when you are looking for unique values, but not when the value occurs multiple times in a list.
This video tutorial shows how to use VLOOKUP to find the last value in a list.
In the video, the COUNTIF function is used to find how many times the lookup value occurs. It is also used to create a column of unique values.
View 5 alternative reasons to use the COUNTIF function
• 5 Alternative Reasons ...
The VLOOKUP function is then used on the column of unique values.
Find more great free tutorials at;
www.computergaga.com
** Online Excel Courses **
The Ultimate Excel Course - Learn Everything ► bit.ly/UltimateExcel
Excel VBA for Beginners ► bit.ly/37XSKfZ
Advanced Excel Tricks ► bit.ly/3CGCm3M
Excel Formulas Made Easy ► bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► bit.ly/2Siivkm
Connect with us!
LinkedIn ► / 18737946
Instagram ► / computergaga1
Twitter ► / computergaga1
Пікірлер: 99
Thanks. Keep they coming.
After going through alotta forums and even the excel's official site and lots of tutorial and only getting some basic stuff, at last i found what i wanted here, Respect
Is there a way to do this on a table? Every time I add a new row there is an unwanted cell target shift that doesn't match what would happen if I was to drag the function down. Any ideas?
Learn from your vids, applied to my job. Thank you so much
Thanks very easy and helpful !
Hi Alan.. excellent.. had not thought of your method to solve this problem. So simple, yet so clever. Outstanding! Thumbs up!
This is brilliant and a useful yet logical alternative to the lookup method.
I applied this formula to find the last payment date of the customer in a big data, it works. Thank you!
Thank You very much. Finally can do it for my business sheet. 2 days I searching this solution and finally I get your video with smart and simple logic
Nice work, very smart way. Thank a lot mate!
I have been trying to figure this out for years. Thanks!
Hi, thanks for the video it's really useful. Quick question for you though, when creating the helper column it is hardcoded to C2&COUNTIF($C$2:C2,C2), is there a way to create this using table referencing?
Ty for the help.
You are my hero!!! Thank you!!!
this is what i'm looking for..thanks mate!
It's very amazing idea . Thanks
Thanks for your help, it makes sense to create a unique identifier and work with that.
It is great thanks! is it possible to find the value previous the last one? I would like to calculate the difference between the last 2 numbers, and i don't want to update the formula every week :)
Good work... and well explained. 🖒
Gr8 Idea. Helped me today. Thanks...