Excel provides many formulas for finding a particular string or text in a list or array. In this video, you will learn how to use the MATCH function.
Excel defines MATCH function as “Returns the relative position of an item in an array that matches a specified value in a specified order”. In simple plain language Match function searches for a value in a defined range and then returns its position.
You will definitely love this video as it not only shows how to compare 2 lists but also demonstrate 2 ways how to handle errors when the comparison finds no match. When there is no match, “N/A” error occurs. From 2:03 to 2:22 of this video, you will learn how to handle the “N/A” error by using the IsNA function. IsNA is used in handling errors in lookup. When there is no match, IsNA converts the N/A error to a logical value TRUE.
Another useful function shown in 3:31 of this video is the use of IsNumber. IsNumber checks if the result of the match is a number. It return FALSE for N/A error
Match function will help you in comparing large scale of data. This video will help you learn how to do this quicker