+ Reply to Thread
Results 1 to 4 of 4

Return date expires on another sheet

  1. #1
    Forum Contributor
    Join Date
    05-16-2012
    Location
    Latina, ITALY
    MS-Off Ver
    Excel 2010--2016
    Posts
    947

    Return date expires on another sheet

    Good evening, I would like your help to find the date in column Au relative to the product of AS column with lot in AT column of Sheet2 and bring it back in the sheet 1 in column Q for the name in column G and lot in column N.
    I tried with the formula

    = IFERROR (INDEX (Sheet2! $ AU $ 2: $ AU $ 5000; SMALL (IF ((Sheet2! $ AU $ 2: $ AU $ 5,000 <> "") * (Sheet2! $ AS $ 2: $ AS $ 5,000 = G3) * (Sheet2! $ AT $ 2: $ AT $ 5,000 = N3); ROW (Sheet2! $ AT $ 2: $ AT $ 5000) -MIN (ROW (Sheet2! $ AT $ 2: $ AT $ 5000)) + 1) ; CONTA.SE ($ N $ 3: N3; N3))); "")
    but it does not give me the desired result.

    * In the attached file I applied the filter in the two sheets, and I would like the AU Sheet2 column dates were given in sheet 1 column Q ..

    Thank you
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2501
    Posts
    18,930

    Re: Return date expires on another sheet

    The following array entered formula* yields the results you expect in column Q:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    *To activate the array formula:
    1) Press the F2 key to make sure that Q20 is in edit mode,
    2) Press Ctrl, Shift and Enter simultaneously,
    3) Copy down as needed.
    Let me know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Forum Contributor
    Join Date
    05-16-2012
    Location
    Latina, ITALY
    MS-Off Ver
    Excel 2010--2016
    Posts
    947

    Re: Return date expires on another sheet

    Perfect, JeteMc thank you so much work correctly
    the next

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2501
    Posts
    18,930

    Re: Return date expires on another sheet

    You're Welcome, thank you for the feedback and marking the thread as 'Solved'. I hope that you have a blessed day.

+ 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. Alert me when a date expires in excel
    By shabbaranks32 in forum Excel General
    Replies: 1
    Last Post: 03-24-2014, 09:34 AM
  2. Replies: 1
    Last Post: 04-24-2013, 06:50 AM
  3. change cell colour when date expires
    By bigdsb in forum Excel General
    Replies: 1
    Last Post: 07-18-2012, 09:09 AM
  4. Replies: 10
    Last Post: 11-10-2010, 03:13 PM
  5. Keeping a cells date when it's condition expires
    By j5gronbach in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-05-2008, 09:57 AM
  6. closing a sheet after webdata expires
    By jamiepullen in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-10-2008, 09:04 AM
  7. [SOLVED] How to set up alarm for cell has entry as date when it expires?
    By Vinod Menon in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-18-2005, 02:05 AM
  8. Message box when date expires
    By EMoe in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-17-2005, 07:05 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