# Search for multiple criteria then return result

1. ## 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. ## 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. ## Re: Search for multiple criteria then return result

That does it.. thanks!

4. ## 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. ## Re: Search for multiple criteria then return result

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

6. ## 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. ## Re: Search for multiple criteria then return result

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

8. ## 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?

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

#### 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