VLOOKUP to Find the Last Value in a List

Learn more incredible Excel Formulas - https://bit.ly/2Ag5AKH

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
https://www.youtube.com/playlist?list=PLxv7tqbNjU9UrIltYKnvMaOOcQ7sVX19p

The VLOOKUP function is then used on the column of unique values.

Find more great free tutorials at;
https://www.computergaga.com

Connect with us!
LinkedIn ► https://www.linkedin.com/company/18737946/
Facebook ► http://www.facebook.com/computergaga
Twitter ► http://www.twitter.com/computergaga1

Видео VLOOKUP to Find the Last Value in a List канала Computergaga