Look Up Specific Text In Row Then Return Its Grouping In Another Row

I have a list of names, and each name belongs to a particular group

I want the group number to auto populate in row 2, so when Andrew adds his name on the bottom of the list, row 2 returns a value of 1, Barry, group 2 and so on.

The list of names and groups will remain the same over time, but the list will be repeated each time that the individual inputs his name.

All information is in one sheet as below

Name
Group

Andrew
1

Barry
2

[Code] ........