this is easy but why can i do it!!!

[eric86vabeach]

ok i have a sheet that looks like this


[TABLE="width: 500"]
<tbody>[TR]
[TD]fst name[/TD]
[TD]lst name[/TD]
[TD]email[/TD]
[TD]bday[/TD]
[TD]jan[/TD]
[TD]feb[/TD]
[TD]apr[/TD]
[TD]may[/TD]
[TD]jun[/TD]
[TD]jul[/TD]
[TD]aug[/TD]
[TD]sep[/TD]
[TD]oct[/TD]
[TD]nov[/TD]
[TD]dec[/TD]
[/TR]
[TR]
[TD]eric[/TD]
[TD]g[/TD]
[TD]eric86@blah[/TD]
[TD]1/30[/TD]
[TD]i want the email show here[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]bob[/TD]
[TD]smith[/TD]
[TD]bob@aol.com[/TD]
[TD]5/12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]email[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

i would like to know what to put in the cells to show the email in the right months that there birthday is in so i can look down the list and email the people that are have there bday that month

can you plzzzzz help me !!!!
thanks for your time

eric

 

[West Man]

[TABLE="width: 288"]
<COLGROUP><COL style="WIDTH: 48pt" span=6 width=64><TBODY>[TR]
[TD="class: xl22, width: 64, bgcolor: white"]fst name[/TD]
[TD="class: xl22, width: 64, bgcolor: white"]lst name[/TD]
[TD="class: xl22, width: 64, bgcolor: white"]email[/TD]
[TD="class: xl22, width: 64, bgcolor: white"]bday[/TD]
[TD="class: xl22, width: 64, bgcolor: white"]jan[/TD]
[TD="class: xl22, width: 64, bgcolor: white"]feb[/TD]
[/TR]
[TR]
[TD="class: xl22, width: 64, bgcolor: white"]eric[/TD]
[TD="class: xl22, width: 64, bgcolor: white"]g[/TD]
[TD="class: xl22, width: 64, bgcolor: white"]eric86@blah[/TD]
[TD="class: xl23, width: 64, bgcolor: white"]30-Jan[/TD]
[TD="class: xl22, width: 64, bgcolor: white"]eric86@blah[/TD]
[TD="class: xl22, width: 64, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl22, width: 64, bgcolor: white"]bob[/TD]
[TD="class: xl22, width: 64, bgcolor: white"]smith[/TD]
[TD="class: xl22, width: 64, bgcolor: white"]bob@aol.com[/TD]
[TD="class: xl23, width: 64, bgcolor: white"]12-Feb[/TD]
[TD="class: xl22, width: 64, bgcolor: white"] [/TD]
[TD="class: xl22, width: 64, bgcolor: white"]bob@aol.com[/TD]
[/TR]
</TBODY>[/TABLE]

in E2 and copied down and across try: =IF(MONTH($D2)=COLUMNS($C2:C2),$C2,"")

 

[tybaltlives]

here is a way...

Excel 2010
	A	B	C	D	E	F	G	H	I
1					1	2	3	4	5
2	First	Last	Emial	Bday	Jan	Feb	Mar	Apr	May
3	A	B	abEmail	30-Jan	abEmail
4	B	C	bcEmail	12-May					bcEmail
Sheet1

Cell Formulas
Range	Formula
F1	=1+E1
F3	=IF(MONTH($D3)=F$1,$C3,"")
F4	=IF(MONTH($D4)=F$1,$C4,"")
G1	=1+F1
G3	=IF(MONTH($D3)=G$1,$C3,"")
G4	=IF(MONTH($D4)=G$1,$C4,"")
H1	=1+G1
H3	=IF(MONTH($D3)=H$1,$C3,"")
H4	=IF(MONTH($D4)=H$1,$C4,"")
I1	=1+H1
I3	=IF(MONTH($D3)=I$1,$C3,"")
I4	=IF(MONTH($D4)=I$1,$C4,"")
E3	=IF(MONTH($D3)=E$1,$C3,"")
E4	=IF(MONTH($D4)=E$1,$C4,"")