Using Index Match for Multiple Value Dropdowns



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!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!