=INDEX(Insp!A2:I300,MATCH('Data Sheet'!A2&'Data

Sheet'!B1,Insp!A2:A300&Insp!D2

300,0))

OK, first part that you have as =INDEX(Insp!A2:I300

should be

=INDEX(Insp!G2:G300

since that is the column with the time remaining, right?

Next, the MATCH() portion - you said your Insp sheet had the S/N and Equip #

in columns A & B. If that is so, then that part of the formula should be

MATCH('Data Sheet'!A2&'Data Sheet'!B1,Insp!A2:A300&Insp!B2:B300,0)

If I've interpreted the column incorrectly, what you want to do is enter the

columns that contain the data you are looking up, in the same order that they

appear in the first part of the formula. So..if Datasheet A corresponds to

Insp A and Datasheet B corresponds to Insp C, you use

MATCH('Data Sheet'!A2&'Data Sheet'!B1,Insp!A2:A300&Insp!C2:C300,0)