+ Reply to Thread
Results 1 to 3 of 3

look up data and transfer according to matching dates

  1. #1
    Forum Contributor
    Join Date
    12-02-2013
    Location
    Melbourne,Australia
    MS-Off Ver
    Excel 2010
    Posts
    101

    look up data and transfer according to matching dates

    On sheet 'MAIN' I have formulas to look up information in a sheet called 'XFLOW A'....would there be a formula which instead of looking at sheet 'XFLOW A' that it instead looks at the date in sheet 'A PERFORMANCE' cell range Data Summary.....it just looks at the date in 'MAIN C5 and in A PERFORMANCE D2:NH2 and if the date match it places the data from A PERFORMANCE into MAIN C6:C19

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    02-19-2013
    Location
    India
    MS-Off Ver
    07/16
    Posts
    2,386

    Re: look up data and transfer according to matching dates

    in main sheet c6 copy and paste
    =INDEX(' A PERFORMANCE'!$D3:$NH3,MATCH($C$5,' A PERFORMANCE'!$D$2:$NH$2,0)) and drag down
    -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST

    More we learn about excel, more it shows us, how less we know about it.

    for chemistry
    https://www.youtube.com/c/chemistrybyshivaansh

  3. #3
    Forum Contributor
    Join Date
    12-02-2013
    Location
    Melbourne,Australia
    MS-Off Ver
    Excel 2010
    Posts
    101

    Re: look up data and transfer according to matching dates

    Thank you hemesh

+ 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: 9
    Last Post: 12-11-2012, 08:15 PM
  2. [SOLVED] Matching Dates and Associated Data
    By reactant in forum Excel General
    Replies: 2
    Last Post: 09-23-2012, 06:52 PM
  3. Replies: 65
    Last Post: 06-12-2012, 11:40 AM
  4. Transfer data for specific dates
    By sandbach in forum Excel General
    Replies: 4
    Last Post: 09-26-2009, 04:04 PM
  5. transfer raw data to other sheets by matching hours and days
    By oakman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-12-2007, 08:18 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