+ Reply to Thread
Results 1 to 7 of 7

How to extract data from one worksheet into another

  1. 06-23-2021, 03:29 AM #1
    Mathaniel
    Mathaniel is offline
    Registered User
    Join Date
    06-23-2021
    Location
    Cheshire
    MS-Off Ver
    Version 2105 of O365
    Posts
    3

    Smile How to extract data from one worksheet into another

    My objective is to pull the data from the STATUS column in Worksheet 2, as per the pic below...

    Pic 1.JPG

    And to have that data shown in the VERIFICATION cells of Worksheet 1 (shown in green), by matching against the corresponding email address. So for example, in the case of DAVE JONES, I would want the VERIFICATION column of Worksheet 1 to display 'Invalid'.

    Capture2.JPG

    To be honest im at a loss as to which function to even begin with so would appreciate help on which function to use and the function calculation itself to get me started. Many thanks in advance.
    Attached Files Attached Files
    Last edited by Mathaniel; 06-23-2021 at 03:44 AM.
    Reply With QuoteRegister To Reply
  2. 06-23-2021, 03:40 AM #2
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,253

    Re: How to extract data from one worksheet into another

    You have posted in the Outlook section - was this a mistake? I can move the thread if needs be.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 06-23-2021, 03:41 AM #3
    Mathaniel
    Mathaniel is offline
    Registered User
    Join Date
    06-23-2021
    Location
    Cheshire
    MS-Off Ver
    Version 2105 of O365
    Posts
    3

    Re: How to extract data from one worksheet into another

    Ahhh yes please - no idea why i did that lol
    Last edited by AliGW; 06-23-2021 at 03:43 AM. Reason: PLEASE don't quote unnecessarily!
    Reply With QuoteRegister To Reply
  4. 06-23-2021, 03:42 AM #4
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,253

    Re: How to extract data from one worksheet into another

    Done.

    There are instructions at the top of the page explaining how to attach your sample workbook.
    Reply With QuoteRegister To Reply
  5. 06-23-2021, 03:59 AM #5
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,959

    Re: How to extract data from one worksheet into another

    In WS1, H2, copied down:

    =IFERROR(VLOOKUP(E3,'Worksheet 2'!B:C,2,FALSE),"")
    Attached Files Attached Files
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
    Reply With QuoteRegister To Reply
  6. 06-23-2021, 04:30 AM #6
    Mathaniel
    Mathaniel is offline
    Registered User
    Join Date
    06-23-2021
    Location
    Cheshire
    MS-Off Ver
    Version 2105 of O365
    Posts
    3

    Re: How to extract data from one worksheet into another

    Glenn thanks for the reply - I've put this into my data and what i didnt appreciate was that Worksheet 1 and Worksheet 2 are ordered differently and have different quantities of email addresses. I.e. there is no way to put them in a comparable order.

    Is there a way to address this and for say excel to look at all the email addresses and appropriate them into Worksheet 1?

    Thanks
    Reply With QuoteRegister To Reply
  7. 06-23-2021, 04:33 AM #7
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,959

    Re: How to extract data from one worksheet into another

    Show me in a new sample exactly where/how it DOES NOT work.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Sub: extract data from one excel worksheet to another worksheet
    By raja1964 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-03-2019, 01:28 PM
  2. Matching three worksheet data and extract data within bracket in 3rd worksheet in C column
    By paradise2sr in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-24-2018, 06:02 PM
  3. Extract data from string and vlookup this data to specific columns on separate worksheet
    By k_mak in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-04-2012, 02:56 AM
  4. Extract data from one worksheet & report it on another worksheet within the same workbook
    By exce1he1p in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-09-2012, 03:10 PM
  5. Using a column of data from 1 worksheet to extract data from another worksheet
    By [email protected] in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-23-2006, 12:35 PM
  6. Extract data from one Worksheet to another
    By extract data fr. one worksheet to anothe in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1