how can i?

[SERVECOLD]

Excel Workbook
	M	N	O	P	Q	R	S	T
2	HomeTeam	AwayTeam	FTHG	FTAG	RESULT	HTR	ATR	FTR
3	West ham	Bolton W	1	3	2	HL	AW	A
Results

Excel 2002

#VALUE!

Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.

Excel Workbook
Name	Refers To
HomeTeam	=Results!$C$2:$C$390
Workbook Defined Names

i have HW,HD,HL an im trying to assign a value to them so if a HW appears in R3 = +2 also AW,AD.AL this would be in U an V for the aways
also i have a drop down box with 3,6,9 in it which i want it to return the last 3,6,9 results which id like it to look like
HW,AL,HD
HW,AL,HD,AL,HW,AD can that be done ? thanks SC

 

[shg]

if English is not your native language, perhaps you might try the non-English forum.

 

[SERVECOLD]

shg excel aint my native language is there a forum for that?