Code/Solution To Search All Text in a Cell and Pull UniqueID Corresponding to the Text

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?

Hi
Try putting an asterisk at end end of the search phrase and still use the cell reference in your VLOOKUP. It works for me.
For example your cell reference would contain *Programmer* when searching for Programmer.
Hope this helps.
Good luck.
Tony

Here it is. I get some results but N/As for a lot, so it is not searching the whole cell, but only the beginning (so it will find results if the name is the first part of the cell, but not if it comes after a /).

Hi
You are getting the #N/A entries because the data you are looking for does not exist in the LOOKUP table.
Tony

Here is the vlookup which gives the results of the Profession Code for different Profession.

Below is the formula used =VLOOKUP("*"&B2&"*",$G$1:$H$6,2,0)

This seem to work too

Please Login or Register  to view this content.