Hello,
I have a list or table of titles, V.P., Vice President, President, CEO and each title has a level associated with it. Example V.P. = 3, Vice President = 3, President =2, CEO =1. I'm using the below code to search through a another list of titles I receive to associate the appropriate levels to their title. The problem I'm having with the below code is that Vice President is returning as a level 2 instead of a level 3.
=VLOOKUP(LOOKUP(9.99E+307,SEARCH('Level List'!$A$2:$A$36,A1),'Level List'!$A$2:$A$36),'Level List'!$A$2:$B$36,{2},FALSE)
"Level List" is the excel worksheet that contains the table of titles and their corresponding level.
Example:
Title Level
Vice Pres 3
Vice President 3
Head of 3
President 2
CFO 1
CIO 1
COO 1
CTO 1
Ect.
A1 is the title that needs a level associated with it.
So Executive Vice President of World Domination needs to return as level 3.
With the code I have now it is returning as level 2.
Could someone let me know how to fix this and let me know if there is an easier way to write the function to do the process I'm trying to achieve?
Bookmarks