Thanks you so much
Although one more small question
i also need to do the bowling, this never worked for me, i think it might be
something to do with the merged cells. I need the same peoples results,
darren ect. they are in alternative inings to when we batted. i need the
selection from s28 and ab60. as you see these are heavily merged cells, could
this be a problem? i dont mind what you do to it, if it works lol. Thanks for
all the help
lyndon

"Max" wrote:

Here's an implemented sample:
http://www.freefilehosting.net/download/39mcb
all_games(1).xls

See sheet: Stats (2),

Input the sheetnames in Q3:X3. Where the sheetname contains an apostrophe,
you need to double the apostrophes, ie input as 2 apostrophes

Example for the sheetname: Westbrook 'A' 1st (with 2 apostrophes)
input it as: Westbrook ''A'' 1st (with both apostrophes doubled up)

Then placed in Q6, copied across/filled down:
=IF(ISNA(MATCH($B6,INDIRECT("'"&Q$3&"'!C6:C16"),0) ),"",
INDEX(INDIRECT("'"&Q$3&"'!AF6:AF16"),MATCH($B6,IND IRECT("'"&Q$3&"'!C6:C16"),0)))

The above set-up will enable you to propagate/populate the top left formula
(in Q6)easily across/down without having to manually adjust the sheet
references.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"dc04wrightl" wrote:
http://www.freefilehosting.net/download/39m5d
ive explained a few things as comments, thanks again, lyndon