Calculating data from another document

Originally Posted by darkyam

You could use =Large(B1:D1,2) for the middle score. It will give the MIN if there are only two. Then just =MIN(B5:B6) for the Decision Score.

For your other issue, try =MATCH("Y",[Book1.xlsx]Table!$AK$2:$AQ$2,0)

=LARGE([Book1.xlsx]Table!$BN$2:[Book1.xlsx]Table!$BP$2,2)

Generated "#NUM!"

=MATCH("Y",[Book1.xlsx]Table!$AK$2:$AQ$2,0)

Worked Perfectly!!

edit: Tried =LARGE([Book1.xlsx]Table!$BN$2:$BP$2,2) as well with the same result.