Results 1 to 4 of 4

Return date expires on another sheet

Threaded View

  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

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