Also do you have a formula for the dues column too? That's the M column.

In Players,

To get the dues (col M), put in M4, array-enter (as before with CSE):
=INDEX(OFFSET(INDIRECT("'2007 Tourn
Reports'!A"&MATCH(TRUE,ISNUMBER(SEARCH(TEXT(H4,"mm mm"),'2007 Tourn
Reports'!$A$1:$A$215)),0)),MATCH(INDIRECT("A"&(INT ((ROWS($1:1)-1)/34)+1)*34-33),'2007 Tourn Reports'!A:A,0)-1,,,8),2)

Copy down to M25. Then copy M4:M25 and paste correspondingly into M38, M72,
etc for the rest of the names.

Here's an implemented sample with the formulas for cols J, K & M
pasted for a couple of names:

http://www.savefile.com/files/987258
Multi Criteria Lookup.xls
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---