Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: Match Date and return corresponding data.

  1. #1
    Join Date
    14th July 2004
    Location
    Australia
    Posts
    156

    Match Date and return corresponding data.

    Hi All,

    I am trying to match the EXACT date from one sheet to another, and if true, then return the corresponding value next to the date, and if false return a blank cell. Matching Data.xlsx

    Please no Macros, Pivot Tables, or VBA. I am not confident with these yet.

    Please refer to spreadsheet for an example and explanation.


    thanking you
    best regards
    SUJU
    Your help is appreciated
    Suju

  2. #2
    Join Date
    10th April 2012
    Posts
    64

    Re: Match Date and return corresponding data.

    HI,

    Copy into cell sheet2!B2, fill down.

    =IF(ISNA(INDEX(Sheet1!$B$1:$D$162,MATCH(Sheet2!A2,Sheet1!$D$1:$D$162,0),1)), " ", INDEX(Sheet1!$B$1:$D$162,MATCH(Sheet2!A2,Sheet1!$D$1:$D$162,0),1))

    Select area sheet1 B1:D162, on the formulas tab select name manager and name this range. Do the same for range sheet1 D1:D162. Once you have named these ranges replace them in the above fomula with the names you just assigned.
    After doing this you will be able to add new data by using the insert row function and the named range will automaticaly update to include the row in the range and will not have to wory about the formula breaking down as your data grows.

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    14th July 2004
    Location
    Australia
    Posts
    156

    Re: Match Date and return corresponding data.

    Hi jmaness

    thanks for your help. The solution worked out perfectly.

    best regards
    SUJU
    Your help is appreciated
    Suju

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Replies: 4
    Last Post: December 13th, 2012, 18:31
  2. Replies: 6
    Last Post: October 5th, 2011, 08:51
  3. Match cell value to table and return date from header row
    By greensparrow in forum EXCEL HELP
    Replies: 2
    Last Post: September 12th, 2011, 01:00
  4. Replies: 9
    Last Post: May 4th, 2011, 21:32
  5. Match By Date And Return Schedule Time
    By firstfan99 in forum EXCEL HELP
    Replies: 1
    Last Post: February 21st, 2008, 22:34

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
  •  
porno