is statement

[Raj]

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.

 

[JLatham]

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

=IF(ISNA(MATCH(C2,Sheet2!D,0)),"no
match",OFFSET(Sheet2!D1,MATCH(C2,Sheet2!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.

 

[JLatham]

But I should have added that what I posted is pretty much just a long way
around to simulate a VLOOKUP() function. This formula does the same thing:
=VLOOKUP(C2,Sheet2!D:E,2,FALSE)