Results 1 to 4 of 4

Formula to lookup data based on 2 criteria

Threaded View

  1. #1
    Registered User
    Join Date
    12-06-2012
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    1

    Formula to lookup data based on 2 criteria

    Hi Guys

    Hope some one can help,

    I need a formula to lookup some data after matching two columns


    b8:b63 contain drivers names, i need to look for the name in column B8:63, match it with the name in column AM9:64,
    Then match the date in B2 with date in cells AN8:EQ8 and return the corresponding value to Cell E8:E63

    For instance if the driver is called driver1 and the date is the 01/12/12 column E would be 10.75, for driver2 8.75, for driver3 8.75

    B..........E..........AM.............AN...............AO.................AP
    ......................................01/12/12.......08/12/12.......15/12/12
    Driver1,.10.75......Driver1.........10.75...........8.75..............8.75
    Driver2,..8.75.......Driver2..........8.75...........10.75..............8.75
    Driver2,..8.75.......Driver3..........8.75............8.75..............10.75

    and when the date changes to the 08/12/12 in B2 the value in E changes for each driver,



    Thanks

    Rich
    Last edited by rthomas; 12-06-2012 at 11:16 PM.

Thread Information

Users Browsing this Thread

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

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