# Excel - IF Function Problem - Expert Solution

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
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.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.