Results 1 to 15 of 15

Collate (lookup) Multiple orders at the same time, based on DATE range in a table

Threaded View

  1. #6
    Registered User
    Join Date
    10-09-2013
    Location
    Dike, IOWA
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: Collate (lookup) Multiple orders at the same time, based on DATE range in a table

    Hope I am saying this correctly...Not really concerned by rank of the PROD AREA, would just like to pull all the orders (& their info) from oldest to newest between the two dates I select, when I tell the formula to only bring in a certain PROD AREA.

    Make any sense?

    I manually inserted the correct answers in the table if that may shed some light??
    Thanks.
    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. How to lookup value based on Date time closest to criteria
    By ilionel1 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-08-2013, 02:01 PM
  2. [SOLVED] Sum like orders, then create multiple rows (prod records) based on sum...
    By mvgoggans in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-12-2013, 03:56 PM
  3. Replies: 10
    Last Post: 02-19-2013, 12:05 PM
  4. [SOLVED] Create a lookup table to award point values based on run time
    By coach touch in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-15-2012, 12:35 PM
  5. Multiple lookup based on date range pricing
    By posttoamit in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-18-2011, 05:52 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