Based on your lines:
.. need to make a table of results, .. if the table was on 1 worksheet
.. and had a name and result on another worksheet.
say darren in b2 and his score in cricket 53 in c2
pete in b3 and his score 32 in c3

Perhaps INDEX/MATCH might provide a way out for you

I've framed up a simple example he
http://www.freefilehosting.net/download/39kh9
Index n Match Example.xls

You should also check out Debra Dalgleish's
nice coverage on INDEX/MATCH at her:
http://www.contextures.com/xlFunctions03.html
INDEX/MATCH
There's some sample workbooks available for d/l & study
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---