+ Reply to Thread
Results 1 to 8 of 8

Search for multiple criteria then return result

  1. #1
    Forum Contributor
    Join Date
    01-29-2009
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    157

    Search for multiple criteria then return result

    I am not very good with using the INDEX function which is what I think I have to do here.

    In Worksheet 1 have a column of dates in C, Column of Names in F. In worksheet 2, I have these same names in Col A, and the Dates in Col C, and a value in Col O. What I need to do in the first worksheet, is look at the Date, and Name, go to Worksheet 2, find the same Date and Name, and return the value form Col O, and place it in Col G. I don't remember being able to use VLOOKUP to find 2 different criteria. Thanks in advance for any help!

    Note: I realize in Sheet 2, the name is before the date, not sure if that matters?

  2. #2
    Valued Forum Contributor Sadath31's Avatar
    Join Date
    03-02-2011
    Location
    Dammam, Saudi Arabia
    MS-Off Ver
    Excel 2019
    Posts
    447

    Re: Search for multiple criteria then return result

    CSE formula in sheet1 G1
    =INDEX(Sheet2!O2:O100,MATCH(C2&F2,Sheet2!C2:C100&Sheet2!A2:A100,0))

  3. #3
    Forum Contributor
    Join Date
    01-29-2009
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    157

    Re: Search for multiple criteria then return result

    That does it.. thanks!

  4. #4
    Forum Contributor
    Join Date
    01-29-2009
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    157

    Re: Search for multiple criteria then return result

    Sadath.. I was wrong, it's not working.. I tried playing with it to figure it out but I can't. A couple of questions.. wouldn't the MATCH part of the formula be "fixed" instead of moving?

    =INDEX(Sheet2!O2:O100,MATCH(C2&F2,Sheet2!C2:C100&Sheet2!A2:A100,0))

    The Data will be very long (I need to keep adding to sheet 2) so I am thinking C2:C10000 and A2:A10000? But these numbers move when I copy it down?

  5. #5
    Forum Contributor day92's Avatar
    Join Date
    04-20-2010
    Location
    Los Angeles
    MS-Off Ver
    Excel 360
    Posts
    600

    Re: Search for multiple criteria then return result

    I would suggest you attached dummy data with the expected results.

  6. #6
    Forum Contributor
    Join Date
    01-29-2009
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    157

    Re: Search for multiple criteria then return result

    Ok hopefully this will help.. Like I said.. I am going to keep adding data to sheet 2.. so the end could be row 7000 or more..

  7. #7
    Forum Contributor
    Join Date
    01-29-2009
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    157

    Re: Search for multiple criteria then return result

    never mind.. too big. I will have to load a small sample later..

  8. #8
    Forum Contributor
    Join Date
    01-29-2009
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    157

    Re: Search for multiple criteria then return result

    Tying to upload the Doc.. but keep getting an error saying there is a problem with the Forum Database?

+ 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