Results 1 to 6 of 6

Pulling Information from separate sheets....

Threaded View

  1. 02-05-2016, 04:43 PM #2
    Teblol
    Teblol is offline
    Forum Contributor
    Join Date
    10-10-2014
    Location
    New Jersey
    MS-Off Ver
    2010 & 2013
    Posts
    276

    Re: Pulling Information from separate sheets....

    So you want a list of ID's on sheet two and when that ID is placed in column A on sheet1 you want the name associated with it to show in the adjacent cell in column B. Is this correct? If so, place this formula in cell B1 on sheet1 and copy down to B3. Or see attached.

    =INDEX(Sheet2!B1:B3,MATCH(A1,Sheet2!A1:A3,0))
    Attached Files Attached Files
    Last edited by Teblol; 02-05-2016 at 04:46 PM.
    Reply With QuoteRegister To Reply
« 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. Pulling Date from separate sheets using INDEX and MATCH
    By mlbdc2012 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-05-2015, 09:49 AM
  2. [SOLVED] Pulling Data from two separate sheets based on criteria on both those sheets
    By mlbdc2012 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-31-2015, 03:57 PM
  3. [SOLVED] pulling information from two sheets, same cell
    By rookie284 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-02-2014, 08:31 PM
  4. [SOLVED] Pulling information from 2 drop down lists on separate tabs
    By pleasesmile in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-14-2013, 10:20 PM
  5. [SOLVED] Pulling Data to separate sheets based on one column
    By joliver in forum Excel General
    Replies: 10
    Last Post: 10-04-2013, 05:14 PM
  6. Pulling information from several sheets depending on criteria
    By qt11 in forum Excel General
    Replies: 4
    Last Post: 03-02-2012, 09:52 AM
  7. Pulling information from three sheets into a fourth automatically?
    By rition@hotmail.com in forum Excel General
    Replies: 3
    Last Post: 01-18-2006, 01: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1