want to do this in a formular but dont know how:

if the text in sheet 1 cell c2 = the text in sheet 2 column d, then return
text in sheet 2 column e associated with text in column d.

I've tried using vlookup, it works with some of the sheets but not all of
them. I have to continiously copy text between the two sheets for it to work.

Please help.