VLOOKUP to Find the Last Value in a List

Learn more incredible Excel Formulas - https://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 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 *** Online Excel Courses ***