Hi,

I have this formula:
=INDEX($A$6:$A$19,MATCH($B$22,H6:H19,0))

And it finds a Value (ex: G2) in the range H6:H19

What if the cell has more than 1 value, example cell H8 has the value "G2, G3".

How can I modify the formula above to find both of them when I alternate the value of B22.

B22 has a pull-down list: G1, G2, G3, G4