Find where the subset value belongs

Hello everyone.

Can anyone help with this.

test.JPG

Please see the attached excel and the image.

This is like a group. For example - Group 1 has a, b ,c , d and 2 and 5
Group 2 has e, f, g, 3, 4
Group 5 has 2
Group 3 has h, i, j and g
and so on....

I have put the required output in col G and H.

Say if I search for value "a", i need output as 1 (since a is under group 1)
If I search for value "e", I need output as 2 (Since it is under group 2. Though 2 it is repeated in B7 and C21, the subset of 2 doesn't change)
If I search for value "g", I need output as "Multiple" (Since g is in both groups 2 and 3)

Note: Subset value of group doesn't change.

Is this possible to do formula or vba? If anyone can help, it would be of great help.

Thank you, appreciate your time.

Regards,
Prasanna.A