Help with a Formula

[cgendron]

Hi, i need help with a formula. It might sounds confusing what i'm asking for so sorry if it doesn't make sense.

I need a formula that will basically copy data from one spreadsheet to another but only if it matches certain fields.

I need something that states If column c (in worksheet A) matches column c (in worksheet B) then copy the data from column D and E (from worksheet B) to column D and E (in worksheet A). I then need to email this spreadsheet but i don't want to send out Worksheet B. If this type of formula is possible, how do i get the data to stick when i email worksheet A without all the formula fields showing my favorite error #VALUE!

thanks

 

[cgendron]

Got it! I had typed the formula for column D and E the same so it was returning date from column E sheet 2 to both column D and E in sheet 1. Thank you very much for this help, i always knew their had to be some formula to do this but could never figure it out. You just saved me two days of work that i can now do in a few hours....Since i have multiple occurances of the same name, i'll just need to change my data series.
Thanks again!!