View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
xlm[_2_] xlm[_2_] is offline
external usenet poster
 
Posts: 29
Default Find common text

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





"Tia" wrote:

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