Copy cell contents if criteria are met

Hi,

Here's what I'm looking to accomplish. If a date in Column A matches any date in Column G, I need the corresponding 'phase' value from Column H copied into Column E. In the example below, A2=G2, so I need the value in H2 copied to E2. I attempted to attach my Excel file here but the attachment tool doesn't seem to be working...I've tried in both Chrome and IE. The file can be viewed here though:

http://s000.tinyupload.com/?file_id=...20228192722791

Thanks!

Excel.PNG

your dates in column A are as text so you need to change it to real date first (both date columns in the same format) then try with

Formula:

Please Login or Register  to view this content.

and drag down

Originally Posted by sandy666

your dates in column A are as text so you need to change it to real date first (both date columns in the same format) then try with

Formula:

Please Login or Register  to view this content.

and drag down

Thanks! That did the trick!

You are welcome

Don't quote post if it is not necessary

If that takes care of your original question, & to say Thanks, please click on Add Reputtion (bottom left corner of the post of the person(s) who helped you)
then select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED.
If you did it already - ignore it.
Thank you.