The lookup list should be created in ascending hierarchical order...
.. i.e. if Ph.D. Is the highest level achievable then Doctorate/Ph.D. should be listed last in your lookup range, M2:N10 (with no blanks).
The Lookup looks for the last item in the lookup range that matches anything in your B2 entry.
Bookmarks