Adding the resulting intersection to an If statement.
 

=IF(Sheet1!AQ81,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.

Adding the resulting intersection to an If statement.
 

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!AQ81,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



"M.A.Tyler" wrote:

=IF(Sheet1!AQ81,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.