Results 1 to 6 of 6

Lookup start and end value based on date range

Threaded View

  1. #1
    Registered User
    Join Date
    04-24-2013
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2007
    Posts
    16

    Lookup start and end value based on date range

    Hello Friends

    I desperately need a solution to get handy summary details from a raw data based on provided date range. Appended is requirement.

    I have 2 sheets in a workbook namely Summary and Data. Data sheet contains the raw data pertaining to day to day business. I want a Summary sheet which should provide me with the details of my business within a period of date range. I have attached the sample sheet for your reference.

    In Summary sheet, if I key “From & To” date in Dispatch Date fields then the below cells should reflect the start & End Order number and also Start & End Invoice number from the Data sheet. I have just manually entered the values to show what I actually need when I key the dates. Please help me with this.

    Thanks in Advance
    Regards,
    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. [SOLVED] Formula to Lookup value based on date within a date range
    By MHamid in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-26-2013, 02:24 PM
  2. Fill Range based on Start/End Date
    By Regenbui in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-20-2013, 08:02 AM
  3. Function that will create a range based on a start date and end date
    By ckosman in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-24-2013, 10:09 PM
  4. Replies: 12
    Last Post: 03-07-2013, 11:02 PM
  5. [SOLVED] Dynamic named range based on a start date and end date
    By Gary Lockton in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 08-06-2012, 07:26 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