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
Watch video Iferror And Index Match Functions online without registration, duration hours minute second in high quality. This video was added by user Akerele Oluwasogo (Mr Excel) 01 January 1970, don't forget to share it with your friends and acquaintances, it has been viewed on our site 15,972 once and liked it 76 people.