Formula required for when a certain text appears in a cell

[flippity]

Hi,
I am relatively new to Excel.

I am looking for a formula which will allow for a particular persons name from a list of names appearing in one cell, to have a
certain title appear in another cell.

For example.

If I have 12 employees, ten being "workers" and another two being "supervisors", if one of the names of
the 10 "workers" appears in say cell A1, Excel will automatically recognise the name as a "worker" and place that title
in say cell B1, alternatively, if the name of one of the two 'supervisors' appears in cell A1, Excel will automatically place the title of
'supervisor' in cell B1.

Any help would be greatly appreciated.

[daffodil11]

Let's pretend you have this list of names and titles in G2:H13.

B1:

=INDEX($H$2:$H$13,MATCH(A1,$G$2:$G$13,0))

or

=LOOKUP(2,1/($G$2:$G$13=A1),$H$2:$H$13)

or

=VLOOUP(A1,$G$2:$H$13,2,0)

And then copy downwards

[FDibbins]

Hi and welcome to the forum

If you only have 2 names, try this...

=IF(OR(A1="xxx",A1="yyy"),"supervisor","worker")

If you start having more than 3 or 4 names (or more than 2-3 categories), then it would probably be better to create a small table, with name and category, then use a VLOOKUP() to pull in thye category

[flippity]

Thanks for your help. I used the VLOOKUP.

Ta/