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...

frist

date of birth

email

jan.

feb

mar

apr

may

jun

jul

aug

sep

oct

nov

dec

eric

1/30/1986

eric86vabeach@yahoo.com

*read note*

bob

2/15/1990

bob@bob.com

*read note

<tbody>
</tbody>

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