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.