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

[eric86vabeach]

ok i have a sheet that looks like this

fst name

lst name

email

bday

jan

feb

apr

may

jun

jul

aug

sep

oct

nov

dec

eric

g

eric86@blah

1/30

i want the email show here

bob

smith

bob@aol.com

5/12

email

<tbody>
</tbody>

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]

fst name	lst name	email	bday	jan	feb
eric	g	eric86@blah	30-Jan	eric86@blah
bob	smith	bob@aol.com	12-Feb		bob@aol.com

<COLGROUP><COL style="WIDTH: 48pt" span=6 width=64><TBODY>
</TBODY>

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,"")