Iferror And Index Match Functions

Excel Video: Learn How to Use the IFERROR, INDEX, and MATCH Functions Together

Excel allows us to lookup values with INDEX and MATCH functions.

The MATCH function returns a row for a value in a table, while the INDEX returns a value for that row.

If no value is found, we can avoid error using the IFERROR function.

This step by step tutorial will assist all levels of Excel users to learn how to use the IFERROR, INDEX and MATCH functions together.

We want to get an Item description in the cell A2, from the lookup table G3:H16, based on Item ID Pkooo3 in the cell A2.

If Item Pkooo3 is not found in the lookup table, we want to return “unavailable” in E2.

The formular looks like:

=IFERROR(INDEX($H$3:$H$16,MATCH(A2,$G$3:$G$16,0)),"Unavailable")

The lookup_value parameter of the MATCH function is A2. The lookup_array is $G$3:$G$16, while the match_type is 0, as we want the exact match.

The result of the MATCH function is the row_num parameter of the INDEX function.

The array the range $H$3:$H$16.

Finally, the value parameter of the IFERROR function is the result of the INDEX function, while the value_if_error is “Unavailable”

Watch the video to learn more

Is the video helpful?

Drop the Excel Topic you want me to create a video for you in the comment box