Better way to select data using if and elseif. Case selection

Hi Folks,

Can anyone help me in finding a better way of writting this code
if name = "Phil" then goto case1
elseif name = "Bob" then goto case 2
elseif name = "Joe" then goto case 1
elseif name = "Fred" then goto case 3
elseif name = "Billy" then goto case 1
elseif name = "Jack" then goto case 3
elseif name = "Jane" then goto case 2

There is no logical relation between the name and the case and i have hundreds of these. I was wodereing if you could do something like
Case1 = "phil", "Joe", "Billy"
Case2 = "bob","Jane"

Etc.

I have tried looking for a soultion but dont really know what to type to get an answer
Any help would be apprecitaed

Perfect, Thanks Olly. I knew it had to be something like this but couldnt find an answer