Index Function with Match

This tutorial explains how to use the Match function to see if a number appears in a list or not. The video explains how to use the ISNA function and the IF function to display New number or Same rather than just N/A . The second part of the video demonstrates how to use the match function with the Index function to provide dynamic intersection from a data list. Match and Index work together to provide a dynamic lookup. Vlookup refers to the first column in a data set. Match and Index can refer to any column not just the first Training at