Find common text

[Tia]

Dear Sir a have a worksheet that contains a name of job titles
A3: A36
B2= Employee name
B3=and than his job title

I want to find what In B40 what is the title that i chose between the
list
wich means what is the common job title that exist in cell A and cell
B

Thank you in advance

 

[xlm]

would you provide a sample of how your employee name and their job titles
data are layout.

--
If this posting was helpful, please click on the Yes button below

Thank You

cheers, francis