Formula Help Please

[How_Do_I]

Hi can anyone see how to solve this one please…<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
I have my data in B3:I4… I want to find out the two teams that my subject team (Newcastle United L14) beat. (The W in C3 and 2 in C4 tells me there were 2 wins)<o></o>
<o> </o>
To complicate this, the wins were against Top 10 teams…<o></o>
<o> </o>
So to find M3:M12 I’d use something like =INDEX(MyTableArea,K3)<o></o>
<o> </o>
Once I have those top ten teams I then need something like:<o></o>
<o> </o>
IF(HomeRange=L14 AND AwayRange=Any one of these 10 (M3-M12) AND FTRange = "W"<o></o>
<o> </o>
How would I start this please… I hope this makes sense…<o></o>

Excel Workbook
	B	C	D	E	F	G	H	I	J	K	L	M	N
3	P	W	D	L	F	A	GD	Pts		1	=INDEX(MyTableArea,K3)	Manchester Utd
4	8	2	4	2	18	13	5	10		2		Arsenal
5										3		Chelsea
6										4		Manchester City
7										5		Tottenham
8										6		Liverpool
9										7		Everton
10										8		Bolton
11										9		Aston Villa
12										10		Newcastle United
13
14											Newcastle United
15											Won
16											IF(HomeRange=L14 AND AwayRange=Any one of these 10 (M3-M12) AND FTRange = "W"
17
Sheet1

 

[How_Do_I]

I added an extra sheet to my book... The following is working, I've pulled two of the 4 Draws (D)... I'm wondering if there's a simpleier way of doing this?

Excel Workbook
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
38	Newcastle United											1	Manchester Utd		#N/A
39												2	Arsenal		249	D
40			Pos	P	W	D	L	F	A	GD		3	Chelsea		149	D
41			T	8	2	4	2	18	13	5		4	Manchester City
42												5	Tottenham
43												6	Liverpool
44			Arsenal									7	Everton
45			Chelsea									8	Bolton
46												9	Aston Villa
47												10	Newcastle United
Sheet1