Results 1 to 3 of 3

Date Range Lookup in Excel

Threaded View

irroberts Date Range Lookup in Excel 06-22-2009, 02:29 AM
DonkeyOte Re: Date Range Lookup in Excel 06-22-2009, 02:36 AM
irroberts Re: Date Range Lookup in Excel 06-22-2009, 02:54 AM
  1. 06-22-2009, 02:29 AM #1
    irroberts is offline
    Registered User
    Join Date
    06-22-2009
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    2

    Date Range Lookup in Excel

    Hi

    I want to calculate a rate (E) based on the work dates (D)/levels(B) in Detail Sheet and then lookup the actual rate based on Rates Sheet (lookup level (COL A) and then find where workdate falls between start COL B and end date COL C) and return the rate in COL D.

    I want this returned to Detail Sheet - Rate Column (E)

    Wondering what the formula for Detail Sheet - Rate Column (E) would be.

    Appreciate any help

    Thanks

    Iain
    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)

Tags for this Thread

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