hi again
yer i think this is what i mean, im still finding it difficult to
understand, sorry i know im annoying lol
do you think you could have a look at my scoresheet, in the stat tab
i have manualy done the results, although i would realy like it to be done
automaticaly, if you can do that i would be realy amazed lol, thanks for your
help
lyndon
"Max" wrote:

Perhaps you meant something like this:
http://www.freefilehosting.net/download/39l4j
Index_n_Match_Example2.xls

In the summary sheet,
With source sheetnames listed in B2 across, player names in A3 down

Put in B3:
=IF(ISNA(MATCH($A3,INDIRECT("'"&B$2&"'!B:B"),0))," ",INDEX(INDIRECT("'"&B$2&"'!C:C"),MATCH($A3,INDIRE CT("'"&B$2&"'!B:B"),0)))
Copy across/fill down to populate the table
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"dc04wrightl" wrote:
hi thanks for the reply
it is working although it is taking a long time to set up, on 18 sheets it
has the same layout is there a way of setting up the table quicker?