Hi Team,
I am trying to create an index/match formula that returns the information from matching cells.
I can get the formula to return the first occurance but none after that. Ideally i'd like all the results in the same cell.
As you can see on the attached I am wanting the rating matrix to look through the register for a match of the two conditions and return the risk ID.
Cell P6 is working to do this but is only returning the first instance (Risk ID 3).
Does anyone know if this is possible?
Bookmarks