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

 

[Meeko]

If i've read the question correctly, the formula for Column D would be :

=VLOOKUP(C1,$A$1:$B$100,2,FALSE)

(Change $A$1:$B$100 to include more rows if your data is longer)

 

[ejr22]

edit beaten

 

[ssmacc]

Thanks very much,

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