Assigning job codes into corresponding job code groups

**ngiachino** · 03-11-2009, 03:03 PM

Hi there - I have a question about excel, and am hoping maybe someone here can help steer me in the right direction.

Lets say I have two sets of data:

Set 1 has a persons name and job code

Set 2 has job codes that match those in set one, but also contains groupings of the job codes into job group codes

For the first set of data, I'd like to know if excel can analyze each job code value in Set 1 and populate the corresponding job group code in a new row.

Does anyone have any suggestions? Thank you!!

Nik

**NBVC** · 03-11-2009, 03:03 PM

Welcome to the forum,

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

**NBVC** · 03-11-2009, 03:14 PM

Maybe you can post an example of what you mean?

**ngiachino** · 03-11-2009, 03:32 PM

I think I may have just figured it out...it's just a simple vlookup.

Source 1:
First, Last, Job Code

John, Doe, TX1001

Source 2:
Job Code, Job Code Group

TX1001, Cardiology

I was struggling because I was thinking the groups and codes were at different grains, but then I just populated the code group for each job code to make it the same level of granularity. Then a vlookup worked fine.

**NBVC** · 03-11-2009, 03:39 PM

Great, glad you resolved it.

Can you please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save