Results 1 to 17 of 17

Pulling data from one sheet to another using index match

Threaded View

  1. #1
    Registered User
    Join Date
    06-09-2015
    Location
    Statesville, NC
    MS-Off Ver
    365
    Posts
    86

    Pulling data from one sheet to another using index match

    Hey all!

    I am trying to pull data from one sheet and insert it into another and I believe Index Match is the formula I need to use, but it's not one that I'm familiar with enough to put together. I have attached a copy of the spreadsheet. The 3 yellow columns (B, D, O) on the "AgentSession.RPT" sheet contain the data that I need to pull and insert on the "Data" sheet in columns A, B and C.

    However, all I need from the "AgentSession.RPT" sheet in Column B are the agent names. Column D, I need exactly what's listed. Column O, I only need the top number for each agent (See Cell O11, O15, O19 and O23).

    Once this information has been extracted properly, I need it to look like the "Data" sheet.

    Thank you in advance for any assistants that you can give. This is a multi-part project, but I'm lost on part 1.
    Attached Files Attached Files
    Last edited by lesiahawk; 07-25-2019 at 10:58 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] INDEX+MATCH instead of VLOOKUP+MATCH, why is INDEX a better choice and how to re-write?
    By Renejorgensen in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-23-2016, 10:54 AM
  2. [SOLVED] Index / Match - match 3 input values and return the results from the index
    By t83357 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-08-2016, 07:34 PM
  3. [SOLVED] Match-Index in stead of Index-Match lookup Array among Arrays
    By Numnum in forum Excel General
    Replies: 2
    Last Post: 10-15-2015, 02:08 PM
  4. INDEX MATCH MATCH/OFFSET MATCH MATCH with named ranges
    By Andrew-Mark in forum Excel General
    Replies: 3
    Last Post: 02-27-2015, 10:56 PM
  5. Replies: 6
    Last Post: 04-30-2014, 02:42 AM
  6. Replies: 6
    Last Post: 11-08-2013, 10:29 PM
  7. Replies: 3
    Last Post: 05-02-2013, 01:31 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1