I am trying to find a solution that gives me the unique ID corresponding to a list of names
Computer Programming
Programmer
Technician
etc
etc
referring to table:
Computer Programming/Programmer, General 11.0201
Data Processing and Data Processing Technology/Technician 11.0301
Data Entry/Microcomputer Applications 11.0601
Web Page, Digital.Multimedia and Information Resources Design 11.0801
Computer Systems Networking and Telecommunications 11.0901
Network and System Administration/Administrator 11.1001
I want to find the corresponding value of the "Name" using VLOOKUP (or another way if you guys have any suggestions). The problem is that the cells containing the names such as "Computer Programming" or "Programmer" or "General" won't find these specific names, e.g., Programmer or General when I use wildcat in my VLOOKUP function, e.g., "*"&B5&"*" but it will find the code 11.0201 for something that comes first in the cell it searches for, such as Computer Programming since it comes first in the cell.
Is there a way for me to use a function or piece of code that goes through each row in a column and searches the box for text containing what I am looking for, and gives me the unique ID corresponding to the box?
Bookmarks