Forumula for matching cells and populating data
Help! I tried to figure this out today at work with no avail.
I have two tabs in a spreadsheet, Sheet1 and Sheet2.
Each sheet has one column for Employee ID#. Sheet2 also has information in a column to the right of the Employee ID# that I want to include in Sheet1, any time the employee ID# matches. I have a blank column in Sheet1 for this data to be copied into.
Each sheet has about 25k lines of data.
Thank you!
Last edited by Rivulet; 09-12-2017 at 08:07 PM.
hi Rivulet. it sounds like VLOOKUP can help you with this. assuming Employee ID both in column A in both sheets. and the column of information you want is in column D of Sheet2, try:
=VLOOKUP(A2,Sheet2!A:D,4,0)
i developed a tool to help people learn VLOOKUP. *try downloading this file here:
https://www.excelforum.com/tips-and-...-how-tool.html
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks