If without gaps

[haybob]

What i want is a formula which will look down the team of the month column and place that month name into the column of the team which was team of the month. i have done a simple if formula but would like it if there wasnt spaces between the months like in column E.

******** ******************** ************************************************************************>

Microsoft Excel - Ex to Alan M.XLS ___Running: xl2002 XP : OS = Windows XP
(F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
F8F9F10F11F12F13F14F15F16 =
	B	C	D	E	F	G
2	Sheet*A		*	Sheet*B		*
3	*	*	*	*	*	*
4	*	*	*	*	*	*
5	*	Team*of*	*	*	*	*
6	Date	the*Month	*	Arsenal*Records		*
7	*	*	*	*	*	*
8	Jan	Leeds	*	Apr	0	*
9	Feb	Liverpool	*	July	0	*
10	Mar	Leeds	*	Aug	0	*
11	Apr	Arsenal	*	Sept	Apr	*
12	May	Chelsea	*	*	0	*
13	Jun	Chelsea	*	*	0	*
14	Jul	Arsenal	*	*	Jul	*
15	Aug	Arsenal	*	*	Aug	*
16	Sept	Arsenal	*	*	Sept	*
Sheet1 *

[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.[/url]