Search For Data in Excel and Copy to Another Spreadsheet

Posted on 2011-10-29
Last Modified: 2012-05-12
Hello – I need some help with Excel. In Spreadsheet A I have all the data I need except for e-mail address, the column in Spreadsheet A for the e-mail address is Column D. Spreadsheet B has the e-mail address in Column D. Is there a way to search on the Last Name & First Name from Spreadsheet A to Spreadsheet B, find the e-mail address for that user in Spreadsheet B and copy and paste it into Spreadsheet A? In spreadsheet A, the last name is in column B and the first name is in column C. In Spreadsheet B, the last name is in column A and the first name is in column B. Spreadsheet A has 1,210 rows of data and Spreadsheet B has 15,037 rows of data.

Question by:vhaperbaugub
    LVL 26

    Expert Comment

    LVL 18

    Accepted Solution

    1.Insert a temporary help column at column A in file B where you enter
    and copy down to the end of data.
    2. Enter this VLOOKUP formula in column D in file A and copy down to the end of data
    3.Copy column D in file A and paste special as values
    4. Delete temporary help column in file B


    Author Comment

    That worked......Thanks!

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
    How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
    The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
    Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now