![]() ![]() So, for this example, the INDEX function will return the value, John. Step 2: INDEX function searches for the 4 th value in the array $B$2:$B$16. ![]() ![]() If no matching was found, the MATCH function would return an error value. It will return 4 as DD is in 4 th position in the lookup_array $A$2:$A$16. Step 1: Match function returns the relative position of lookup_value D2.These are the steps to analyze the above formula: This time if no matching is found, the cell will show blank as the IFERROR function’s value_if_error argument is blank. We shall work again with the same data but this time we shall use this formula in cell E2: =IFERROR(INDEX(B2:B16, MATCH(D2,A2:A16,0)), “”) Read More: How to Match Two Columns and Return a Third in Excel 2) Compare two columns and return value from the third column (using INDEX and MATCH functions) If you don’t know how Excel’s VLOOKUP formula works, then give it a revision (from the image below) If you observe the image carefully, you will find that the formula is actually self-explanatory. To understand this formula, you have to know the syntax of IFERROR and VLOOKUP Excel functions. Input this formula in cell E2: =IFERROR(VLOOKUP(D2,project_manager,2,FALSE), “Not Assigned”) In cell D2, the Project coordinator might input a Project name and want to see who the Manager of the Project is. In the following spreadsheet, you are seeing a list of some Projects and their Managers. Further Readings 1) Compare two columns and return value from third column (using VLOOKUP formula) ![]()
0 Comments
Leave a Reply. |