help plz this should be fast and easy for you!!!

[eric86vabeach]

ok i have a sheet that looks like this and all i want it to do is this...

[TABLE="width: 500"]
<tbody>[TR]
[TD]frist[/TD]
[TD]date of birth[/TD]
[TD]email[/TD]
[TD]jan.[/TD]
[TD]feb[/TD]
[TD]mar[/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]1/30/1986[/TD]
[TD]eric86vabeach@yahoo.com[/TD]
[TD]*read note*[/TD]
[TD][/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]2/15/1990[/TD]
[TD]bob@bob.com[/TD]
[TD][/TD]
[TD]*read note[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

ok in cell "D3" i would like it to show "eric86vabeach@yahoo.com"
and in "E3" i would like to show "bob@bob.com"

so i would like if your email shows up in month of "date of Birth"

i would like to use this so i can email see who to email in what month

 

[alansidman]

IN D3, type =if(Month(B3)=1,C3,"") and copy down
In E3, type =if(Month(B3)=2,C3,"") and copy down
Do this across your columns until December, changing the formula for each month.

 

[eric86vabeach]

thanks a ton it work

 

[ukmikeb]

Or in D3 :-

=IF(MONTH($B3)=COLUMNS($D:D),$C3,"")

copy across to COLUMN O and down to your hearts content.

hth