Using Index Match for Multiple Value Dropdowns
Hello,
I'm trying to utilize index matching for some metadata sheets and using the formula I am currently utilizing, the data appears blank.
The formula currently being used is:
=IFERROR(INDEX({Portfolio Summary Data}, MATCH($[Project ID]@row, {Project ID}, 0), MATCH([Impact/Benefits]$1, {Portfolio Summary Header Row}, 0)), "")
This works for all fields except the multiselect dropdowns.
Source Sheet:
Metadata Sheet:
I'm receiving blank outputs.
Help please!
Answers
-
What happens when you remove the IFERROR?
-
Hi Paul, thanks for responding! I receive #NO MATCH despite the formula working on the other columns.
-
Hi there, despite the formula working elsewhere without the IFERROR, I receive #NO MATCH.
-
That means it is not finding either the project id or the Audience$1 value in the reference sheet.
Help Article Resources
Categories
Check out the Formula Handbook template!