Can anyone suggest a way of doing this. I want to be able to allocate
resources and/or roles.

I have a number of staff members each with a specific role. I have a
dropdown list in the cell so the user can select the relevant staff member.
A VLOOKUP then selects the selected staff members role using named ranges and
a separate spreadsheet. If there is not specific staff member available I
want the user to be able to select a staff member of "To Recruit" and then be
able to select a role type from a dropdown list. My list of staff names
contains around 100 people and there are over 30 possible roles which is why
I have used named ranges
e.g.
Mr A is a BA
Mr B is a Programmer
Mr C is a Tester
The possible available types of roles I have is BA, Programmer, Tester and
Manager.

The dropdown in cell A1 contains Mr A, Mr B, Mr C, & To Recruit

If user selects Mr A in A1 then BA shows in cell B1
If user selects Mr B then Programmer shows in cell B1
If user selects To Recruit in A1 then a dropdown list containing BA,
Programmer, Tester, Manager shows in B1 and the user must select one from it.

So my spreadsheet could show
A B
1 Mr C Tester (auto populated)
2 To Recruit Tester (selected via dropdown)
3 To Recruit BA (selected via dropdown)
4 Mr B Programmer (auto populated)

Thanks