Try this formula somewhere on Sheet1, doesn't really matter where, except
that it cannot be in C2.

=IF(ISNA(MATCH(C2,Sheet2!D:D,0)),"no
match",OFFSET(Sheet2!D1,MATCH(C2,Sheet2!D:D,0)-1,1))

Remember there really isn't a line feed in the middle of that - it is one
long formula to be entered.

Hope this helps you.

"Raj" wrote:

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.