+ Reply to Thread
Results 1 to 5 of 5

Return Delivery Date or state 'No Delivery'

  1. #1
    Registered User
    Join Date
    06-30-2010
    Location
    swindon, england
    MS-Off Ver
    Office 365
    Posts
    90

    Return Delivery Date or state 'No Delivery'

    I am trying to create a formula to lookup and match two values and return a corresponding delivery date, if those two values are matched.
    If there is no corresponding delivery or values cannot be match, the result should state 'No Delivery'

    I've attached a basic spreadsheet example.

    I'd like to match the values in column A with column E, the value in column B with column F, and return into column C the data from column G.
    If there is no data to return, then the result would state 'No Delivery'.

    If anyone could help it would be much appreciated.

    Thanks

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,984

    Re: Return Delivery Date or state 'No Delivery'

    In C2, copied down:

    =IFERROR(INDEX($G$2:$G$7,MATCH(1,INDEX(($E$2:$E$7=A2)*($F$2:$F$7=B2),0),0)),"No Delivery")
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: Return Delivery Date or state 'No Delivery'

    in C2
    =IFERROR(LOOKUP(2,1/((A2=E$2:E$7)*(B2=F$2:F$7)),(G$2:G$7)),"No Delivery")
    and copy down the column
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  4. #4
    Registered User
    Join Date
    06-30-2010
    Location
    swindon, england
    MS-Off Ver
    Office 365
    Posts
    90

    Re: Return Delivery Date or state 'No Delivery'

    Thanks that's great.

  5. #5
    Registered User
    Join Date
    06-30-2010
    Location
    swindon, england
    MS-Off Ver
    Office 365
    Posts
    90

    Re: Return Delivery Date or state 'No Delivery'

    Thanks very much.

+ 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. How to find time passed between last return till next delivery
    By whatever61 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-23-2019, 11:09 AM
  2. [SOLVED] Delivery date depending on job
    By deanblew in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-05-2016, 09:13 AM
  3. Get the last delivery date from an array run.
    By irfanparbatani in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-05-2014, 04:41 AM
  4. Replies: 2
    Last Post: 06-05-2013, 12:14 PM
  5. Delivery date calculation
    By ows246 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-07-2013, 07:49 AM
  6. Excel validating with =NOW() with delivery date
    By caf20012 in forum Excel General
    Replies: 3
    Last Post: 07-12-2012, 03:46 PM
  7. [SOLVED] Delivery note or delivery order sheet
    By Roy Istanbouli in forum Excel General
    Replies: 1
    Last Post: 01-21-2005, 02:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1