Results 1 to 7 of 7

Lookup value based on date range and multiple criteria

Threaded View

  1. 02-07-2014, 03:38 PM #1
    jsclark
    jsclark is offline
    Registered User
    Join Date
    04-17-2007
    Posts
    17

    Lookup value based on date range and multiple criteria

    I have three spreadsheets. I am looking for a formula that will Lookup the CODE in Sheet 2 that matches C1 & B2 in Sheet 3 and return the value in Sheet 1 for that CODE that falls in the Date Range in Sheet 1 B1: H2. I have attached a sample of what I am working with and hoping someone can assist? Thank you in advance to taking the time to look!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Collate (lookup) Multiple orders at the same time, based on DATE range in a table
    By Prodschdler in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 11-05-2013, 05:19 PM
  2. Excel Lookup with multiple criteria and date range match
    By denniswtlx in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-06-2013, 02:25 PM
  3. Lookup values in multiple columns based on a date range, return single value per criteria
    By mprisbrey in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-19-2013, 12:05 PM
  4. PLEASE HELP-Lookup with Multiple Criteria,with date range,and multiple results SCHEDULE
    By Porsche944 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 02-07-2013, 02:22 AM
  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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1