Adding the resulting intersection to an If statement.

[Guest]

=IF(Sheet1!AQ8>1,INT(Sheet1!W8/100)*60+MOD(Sheet1!W8,100)+(Sheet1!AR8/10)+INDEX('Adjust
Pts'!$C$8:$Q$651,MATCH(Pace!J4,'Adjust
Pts'!$C$6:$Q$6,0),MATCH(Pace!L4,'Adjust
Pts'!$B$8:$B$651,0)),INT(Sheet1!W8/100)*60+MOD(Sheet1!W8,100))+INDEX('Adjust
Pts'!$C$8:$Q$651,MATCH(Pace!J4,'Adjust
Pts'!$C$6:$Q$6,0),MATCH(Pace!L4,'Adjust Pts'!$B$8:$B$651,0))

Is it possible to add the result of an Index, Match, Match to an If
statement? The above formula gives me a #Value! error. I could do this in
seperate columns, but thought this might work.

 

[Guest]

The formula is constructed of an IF() function summed to an INDEX() function:
=IF() + INDEX()

The above IF() function also contains a nested INDEX() function:
=IF(Sheet1!AQ8>1,INT()*60+MOD()+(Sheet1!AR8/10)+INDEX(),INT(Sheet1!W8/100)*60+MOD())

From Help, the syntax of the INDEX function is:
INDEX(array, row_num, column_num)

Your function appears to have the row_num and column_num arguments reversed.
For example:
INDEX('Adjust Pts'!$C$8:$Q$651,MATCH(Pace!J4,'Adjust
Pts'!$C$6:$Q$6,0),MATCH(Pace!L4,'Adjust Pts'!$B$8:$B$651,0))

Should be:
INDEX('Adjust Pts'!$C$8:$Q$651,MATCH(Pace!L4,'Adjust
Pts'!$B$8:$B$651,0),MATCH(Pace!J4,'Adjust Pts'!$C$6:$Q$6,0))

If I'm correct then the above INDEX() function by itself should return the
#REF! error code.

Regards,
Greg