We can use the ISERROR() with the MATCH function in the following way. Let us see the steps with an example. The following image shows two tables. The first table contains a list of athletes who qualified for Round 1 in an event. And the second table contains the complete list of athletes who participated in the Round 1 of the event. Suppose we need to update the qualification status of all the athletes in column D and display the data in column E of the second table. Then, we can perform the calculations in the target cells using the ISERROR() with the functions MATCH, INDEX, and IF. • Step 1: Select the target cell E3, enter the below formula, and press Enter. =IF(ISERROR(INDEX($B$3:$B$9,MATCH(D3,$A$3:$A$9,0))),"Not Qualified",INDEX($B$3:$B$9,MATCH(D3,$A$3:$A$9,0))) • Step 2: Drag the fill handle downwards to copy the formula in cells E4:E12. Let us see how the formula works using the target cell E12 expression. First, the MATCH() inside the INDEX(), within the ISERROR(), searches the name in cell D12, Lowell Vasquez, in the list of qualified athletes in column A. As there is no match, the function returns the #N/A error. And as the INDEX() has to check for the #N/A error in the cell range B3:B9, it also returns the #N/A error. Now, since the input to the ISERROR() is the #N/A error, it returns TRUE. Finally, the IF condition is true; thus, its output displayed in the target cell D12 is the term Not Qualified.