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.

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.

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)


"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.