Hi
I have two worksheets
1) Worksheet A - need to match the title to worksheet b to get it's answer for CL column
sample.png
I try these method and it didn't give the right answers for most
1) VLOOKUP($E2&"*",worksheetb$A$2:$C$13,2,TRUE) and the answer is not right - it's not pick the right CL to the title.
can anyone help. I am trying to find partial match of worksheet A job title eg if it's Senior Associate Director (XXX) to match into Worksheet B Title Senior Associate Director and pick up the CL column which s CL2 to Worksheet A..
Please advise the formula that can partial match the title and pick back the answer.
Do I need to change the table for worksheet B? I am lost and not sure of the formula to use. Thank you
Regards
Bookmarks