If there will only be one match, or if you'll want to sum the C values if
there are multiple matches, then you could use SUMPRODUCT.

=SUMPRODUCT(--(A2:A5=Sheet2!A15),--(B2:B5=Sheet2!A14),C2:C5)

HTH,
Paul

--

"Qaspec" wrote in message
...
Sheet1
A B C
1 Date Time Score
2 3/1/08 0000 91
3 3/1/08 0600 96
4 3/2/08 0000 95
5 3/2/08 0600 97

Sheet2
A14 = 0000
B12 = 3/2/08

Times and scores can be duplicated and date and scores can be duplicated
to
i need to validate by date and time which were created seperately by
another
system. i'd like to do this without creating an extra or hidden columns.

I would like a formula to return the scrore 95 from sheet 1 that
corresponds
to