+ Reply to Thread
Results 1 to 4 of 4

Formula to lookup data based on 2 criteria

  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.

  2. #2
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Help please, Problem with a formula

    Welcome to the forum, can you edit the title of your thread that would better explain your query.
    as per forum rules.
    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  3. #3
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: Formula to lookup data based on 2 criteria

    hi rthomas, i'm a little confused about this part:
    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
    they dont start & end at the same row?
    try:
    Please Login or Register  to view this content.
    if there will be instances no match are found & you want to show a blank, then use ISNA:
    Please Login or Register  to view this content.
    if it doesnt work, uploading a sample Excel file will enable us to help you better. to upload, press "Go Advanced" beside the "Post Quick Reply" button & click on the paperclip icon

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Formula to lookup data based on 2 criteria

    To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

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