If you haven’t watched Part 1 of the Excel tutorial series, please go and watch that first. Remember to download the Follow Along Workbook to follow along with the video. If you’ve already completed Part 1, use the same file that you worked on for this part.
Error! You must specify an anchor parameter if you are not using the auto_thumb option.
In this second part, we’re going to go over one of the most powerful functions in Excel: INDEX, and the function MATCH that make it great. With these two functions, Excel is able to filter and find the exact values you need from a large table. Don’t miss this one!
As usual, please leave any questions you may have in the comments section. Enjoy.
Mastered Part 2? Go to Part 3 now!