In this example we use the MATCH function to return an exact match so we set the third argument to 0. MATCH StacyA2D20 is searching for Stacy in the range A2D2 and returns 3 as the result. Col_num the column number from which the value is to be fetched.
Formula 1 for table 1.
No matter whether you are using Excel or Google Sheets you can use the formula same way. INDEX B5E9MATCH H4 B5B9FALSE2 which returns 1995 the year the movie Toy Story was released. To write the formula combining the two we use the MATCH function to for the row_num argument. To give you an example of the MATCH formula if we were to select the entire left hand column and then specify WA as our lookup value the MATCH formula would return the number 6.