# Excel - COLUMN Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

Hi, I need to find information in one workbook and have it automatically populate in another. Example - Workbook A has employee social security numbers in column D. I need to have it populate in another workbook matching the correct employee last name
Solved by V. A. in 13 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 25/05/2018 - 01:24
Hi
Excelchat Expert 25/05/2018 - 01:24
Welcome to Got it Pro
User 25/05/2018 - 01:25
Hi, I have two spreadsheets I need to merge specific info
Excelchat Expert 25/05/2018 - 01:25
Can you paste your data or share your excel so that i can help better
User 25/05/2018 - 01:25
Unfortunately no, It is protected
User 25/05/2018 - 01:26
I can give you an example
Excelchat Expert 25/05/2018 - 01:26
Can you paste some sample data on spreadsheet on right
Excelchat Expert 25/05/2018 - 01:26
So that i can help you out
User 25/05/2018 - 01:26
OK
User 25/05/2018 - 01:27
I have one worksheet that has ee data as shown.
Excelchat Expert 25/05/2018 - 01:27
ok
Excelchat Expert 25/05/2018 - 01:27
Also paste the other data as well
User 25/05/2018 - 01:29
I have another workbook (completely different file) that has employees listed by social security number. I need to create a formula in the workbook shown to extract the social security number in Workbook B and have it match the last name.
Excelchat Expert 25/05/2018 - 01:29
can you paste that data in sheet 2?
User 25/05/2018 - 01:31
It's pretty simplistic data. I just don't know how to get one workbook to read from another workbook.
Excelchat Expert 25/05/2018 - 01:31
=VLOOKUP(B2,Sheet2!\$C:\$D,2,0)
Excelchat Expert 25/05/2018 - 01:31
This is the formula we should use
Excelchat Expert 25/05/2018 - 01:31
See cell C2 on sheet 1
Excelchat Expert 25/05/2018 - 01:31
Did you see?
User 25/05/2018 - 01:31
So just to make sure I understand the concept
Excelchat Expert 25/05/2018 - 01:32
Ok
User 25/05/2018 - 01:32
You used Column B2 on sheet one to match column C2 and if it matches add in D2
Excelchat Expert 25/05/2018 - 01:32
Let me know if the formula i used helps
Excelchat Expert 25/05/2018 - 01:33
Yes
User 25/05/2018 - 01:33
What does the D,2,0 mean?
Excelchat Expert 25/05/2018 - 01:33
D is the column which we want to populate
Excelchat Expert 25/05/2018 - 01:33
2 is the 2nd column out of C:D
Excelchat Expert 25/05/2018 - 01:34
and 0 means exact match, wherever exactly the last name matches it returns the value in column D
User 25/05/2018 - 01:35
You are spectacular - you saved me hours of work and not getting grief from my high tech young boss!!
Excelchat Expert 25/05/2018 - 01:35
Thanks
User 25/05/2018 - 01:35
I'm an old lady who still works old school. Thank you so much for your help!!!
Excelchat Expert 25/05/2018 - 01:35
Please do give good rating and reviews
Excelchat Expert 25/05/2018 - 01:35
It really helps
Excelchat Expert 25/05/2018 - 01:36
I am happy to have helped you out
User 25/05/2018 - 01:36
I will - I used to be a customer service manager. I know how important it is
Excelchat Expert 25/05/2018 - 01:36
Hope you had a good experience
Excelchat Expert 25/05/2018 - 01:36
Great
Excelchat Expert 25/05/2018 - 01:36
Have a great day
User 25/05/2018 - 01:36
You too
Excelchat Expert 25/05/2018 - 01:36
You can provide your rating when you end the session
Excelchat Expert 25/05/2018 - 01:36
Take Care
User 25/05/2018 - 01:37
=0)

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.

## Click here to get your free Excelchat help session

Trusted by people who work at