**Question description:**

*This user has given permission to use the problem statement for this
blog.*

Dataset A is a list of nearly 1,200 occupations (column A) and a Job Zone Value (column b).
Dataset B is a list of 100-150 occupations that are a subset of the 1,200 in Dataset A.
I need to append the Job Zone Value from Dataset A to Dataset B when the occupation is an exact match.
Example: Dataset A
Column A Column B
Chemical Engineer 4
If Chemical Engineer appears in Column A of Dataset B then append the value (4) in column B

Solved by K. L. in 20 mins

This is the chat thread from the real Excelchat help session. It contains no private user
information.

Excelchat Expert
12/04/2018 - 06:52

Welcome, Thanks for choosing Got It Pro-Excel
How may I help you today?

Excelchat Expert
12/04/2018 - 06:54

Let me clarify the question

Excelchat Expert
12/04/2018 - 06:56

If the occupation of dataset B is same as that of dataset A then you want the second column of dataset B to get appended in the corresponding entry of dataset B

Excelchat Expert
12/04/2018 - 06:56

Right?

User
12/04/2018 - 06:56

Yes

Excelchat Expert
12/04/2018 - 06:56

Ok

Excelchat Expert
12/04/2018 - 06:57

You can do it by applying vlookup

Excelchat Expert
12/04/2018 - 06:57

l will show you an example

Excelchat Expert
12/04/2018 - 06:59

In the first sheet, you have some occupations and their corresponding job zone value

Excelchat Expert
12/04/2018 - 06:59

In the sheet 2, you have random occupations

Excelchat Expert
12/04/2018 - 07:00

you want corresponding job zone values in sheet 2

Excelchat Expert
12/04/2018 - 07:00

Right?

Excelchat Expert
12/04/2018 - 07:00

You apply the following formula

Excelchat Expert
12/04/2018 - 07:01

Now you drag down by the little dot at the right bottom corner

Excelchat Expert
12/04/2018 - 07:01

Till the last cell

User
12/04/2018 - 07:02

What Formula?

Excelchat Expert
12/04/2018 - 07:02

=vlookup(A2,Sheet1!$A$2:$B$6,2,0)

Excelchat Expert
12/04/2018 - 07:02

Shall I walk you through the example?

Excelchat Expert
12/04/2018 - 07:04

Will this resolve your problem?

User
12/04/2018 - 07:05

I have a phone call come in. I think I got.

Excelchat Expert
12/04/2018 - 07:05

Ok

Excelchat Expert
12/04/2018 - 07:05

Thank you

Excelchat Expert
12/04/2018 - 07:05

Thank you for using Got It Pro-Excel
Have a good day

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user
information.*