I have been working on a 2 Part Complex Formula for Matching Multiple Results for a few weeks and having some issues getting the correct formula written. Below are the two parts that I am having issues with:
1.) MATCH: I am looking to leverage the MATCH function to pull a row number for a partial-exact match of data within a cell. For example, I am trying pull results for cells containing the text "SI-4".
Below is an example of a cell I would want it to match:
""SC-7(19), SI-4, SI-4(1), SI-4(2), SI-4(4), SI-4(5), SI-4(7), SI-4(9), SI-4(11), SI-4(12), SI-7, SI-7(1), SI-7(7)""
Below is an example of a cell that should NOT be matched:
"AC-18, SI-4(14), SI-4(15)"
To match the "SI-4" data within the cell, I was using the "*"&SI-4&"*", but leverage those wild cards pulls also matches the second cell which it should not. I though that only using the wild card option before the content would produce the correct results, but it does not.
2.) INDEX + MATCH/OFFSET: Once I am able to resolve the situation above, I would be interested in writing a formula to include both INDEX + MATCH. Right now I am primarily using MATCH/OFFSET as a helper function to pull row data and then using the INDEX function to pull multiple results from with a table.
Any help with getting this resolved would be greatly appreciated!
Bookmarks