Cell Value Picked by text in list

[Ajaxs87]

I want a formula that picks either Group 1, Group 2, Group 3. Based on the text under each Group. I attached a practice piece as a reference of what I mean. Any help would be appreciated. Thank you

[Estevaoba]

Assuming text in F2, try:

=INDEX(A1:C1,AGGREGATE(15,6,COLUMN(1:1)/(A2:C10=F2),1))

Good luck!

[Ajaxs87]

Thank you! If you have free time, can you lightly explain how you did this? If not I greatly appreciate you, for the help you have already accomplished!

[Estevaoba]

You're welcome. Glad to help.

Select the argument COLUMN(1:1)/(A2:C10=F2) in the formula bar, press the F9 key and you'll see that Excel creates an array of values and errors like #DIV/0!, #DIV/0!, 3, #NA,... where here, for instance, the third column finds a match (Megaman was selected), so it returns 3, i.e, the value is found in the third column.
The AGGREGATE function, when its first argument is selected as 15 (SMALL), returns the smallest value that matches criterion.

Thank you for the feedback and for the reputation added.
Have a blessed day!