+ Reply to Thread
Results 1 to 3 of 3

Dragging in text from adjacent cells

  1. #1
    Registered User
    Join Date
    07-10-2015
    Location
    London, England
    MS-Off Ver
    Office Professional 2010
    Posts
    10

    Dragging in text from adjacent cells

    Hey Guys,

    I have a spreadsheet with two tabs (sheet1 and sheet2). Sheet1 has data in it, and sheet two is where I wish to pull data into from sheet1.

    My data is set out similarly to the attached, but it is huge. I would like in sheet two to be able to to somehow tell excel to "FIND A SPECIFIC UNIQUE IDENTIFIER, AND PULL IN THE INFORMATION THAT LIES IN THE TWO CELLS TO THE LEFT OF IT". So here basically i want to say look for the unique identifier and then pull in the game time and run time for it.

    is there a way to do this?

    Thank you in advance

    Games.png

    Game Times.xlsx

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,577

    Re: Dragging in text from adjacent cells

    With your unique ID in A1
    In B2 copied to C2

    =IFERROR(INDEX(Sheet1!B$3:B$17,MATCH($A$1, Sheet1!$D$3:$D$17,0)), INDEX(Sheet1!G$3:G$17, MATCH($A$1, Sheet1!$I$3:$I$17,0)))
    Attached Files Attached Files
    ChemistB
    My 2

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Registered User
    Join Date
    07-10-2015
    Location
    London, England
    MS-Off Ver
    Office Professional 2010
    Posts
    10

    Re: Dragging in text from adjacent cells

    Thank you so much ChemistB that works perfectly!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 11
    Last Post: 04-30-2015, 05:35 PM
  2. Replies: 4
    Last Post: 01-13-2014, 08:13 AM
  3. Replies: 2
    Last Post: 09-07-2013, 07:50 PM
  4. Formula needed for dividing 2 sets of cells and excluding adjacent text cells
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-07-2013, 06:45 PM
  5. [SOLVED] Splitting text from one cell into separate text fragments, Located in adjacent cells
    By onsid in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-15-2013, 08:32 PM
  6. [SOLVED] Populating subcategory cells with adjacent text from category cells
    By MrRed in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-25-2012, 08:21 AM
  7. Dragging Formulas to Adjacent Cells
    By skratchmo in forum Excel General
    Replies: 5
    Last Post: 04-27-2011, 11:35 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1