Excel Help!

[ssmacc]

Hello,

Can someone help me out with an Excel (2003) problem?

Basically I have a full list of ‘Subjects’ in column ‘A’ and a list of Dates in column ‘B’.

I have pasted another row of 'Subjects' in Column ‘C’, all these 'Subjects' are contained somewhere within Column ‘A’, ideally I’d like the correct Date from Column ‘B’ to be returned in Column ‘D’ (next to the correct 'Subject' from 'C'), can anyone do this?

Any help appreciated as I’m currently performing this manually!

Thanks

 

[ssmacc]

Thanks very much,

This will no doubt help preserve my vision in the future!