Partial match index match with array values shorter than match value

[isa2904]

Problem:
Trying to run an index match_partial match on a long column of values to return the desired result but have been getting an #NA. Current formula without changes: =INDEX(level,MATCH("*"&J3,title,0))

So I'm trying to match these values to return "Middle Management" for values that contain "Director"
title return column
Assistant Director
Associate Director
Account Director
Account Specialist
Facilitator
...etc.

Lookup Array
title level
Director Middle Management
Coordinator Entry Level
Manager Intermediate
...etc ....etc

It seems the formula with wildcard value/concatenate will only work when the values in the Lookup Table are shorter than the lookup value.
I can't remove the text in the beginning to search because the number of characters differ for each lookup value. (i.e. =INDEX(level,MATCH(RIGHT(J2,LEN(J2)-9),title,0))

Anybody has a better, more accurate solution? Thank you in advance!

 

[DanteAmor]

Hi and welcome to MrExcel
It is not appreciated how you have the data.
You could copy the cells and paste here or use the XL2BB tool.

title return column
Your data is like this:

Book1
	A
1	Assistant Director
2	Associate Director
3	Account Director
4	Account Specialist
5	Facilitator
Sheet

Or like this:

Book1
	A	B
1	Assistant	Director
2	Associate	Director
3	Account	Director
4	Account	Specialist
5	Facilitator
Sheet

______________________________________________________________
title level
Like this:

Book1
	A
1	Director Middle Management
2	Coordinator Entry Level
3	Manager Intermediate
Sheet

Or like this:

Book1
	A	B
1	Director	Middle Management
2	Coordinator	Entry Level
3	Manager	Intermediate
Sheet