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?

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

That does it.. thanks!

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?

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

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

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

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