Use the same define names provided by Harlan, and add the following
defined names...

Col_A_N:

=N(INDIRECT("'"&XWSLST&"'!A"&(2+MOD(S,N))))

Col_A_T:

=T(INDIRECT("'"&XWSLST&"'!A"&(2+MOD(S,N))))

Then try the following formula...

=INDEX(Col_A_N,MATCH(LARGE(IF(RIGHT(Col_A_T,5)="To tal",IF(LEFT(Col_A_T,5)
<"Grand",Col_B-S/10^5)),ROWS(D$2:D2)),Col_B-S/10^5,0)-1)

Note that I've assumed the value to return is a number, as per your
sample data in a previous thread.

Hope this helps!

In article .com,
"Fin Fang Foom" wrote:

I would like to get this formula below to work across worksheets.


=INDEX(A$1:A$99,MATCH(LARGE(IF(RIGHT($A$2:$A$100,5 )="Total",IF(LEFT($A
$2:$A$100,5)<"Grand",$B$2:$B$100-ROW($B$2:$B$100)/10^5)),ROWS(D
$2:D2)),$B$2:$B$100-ROW($B$2:$B$100)/10^5,0))


The formula above list names from column A that has the largest number
in column B. It also accounts for duplicates.

Any Ideas will be appreciated.