Unmatching row numbers

[Creperum]

Okay, I'm trying to use this formula to tell me if there is a matching
number in another worksheet

IF(Sheet1!$E$1:$E$65536 = "Value from Sheet2 (D3)","Found","")

But Excell will only tell me it is "found" when the row numbers match,
how can I overcome this setback.

Thanks Again,
~E~


-------------------------------------------------
Dear Creperum

You dont mention if the row numbers need to match (eg
sheet1 d1=sheet2 e1=Sheet3 e1 or whether you only want
sheet1 a1 to look at both ranges to see if the value is
present. depending on which way you want to do it, you
will still need an if statement. Assuming you only want
the text "Found" to appear in the cell that you specify
the following formula will do the job for you.

What you will need to enter in the relevant cell in sheet1
columnD is something along these lines

IF(Sheet2!$E$1:$E$65536 = "the text you are looking
for","Found",If(Sheet3!$E$1:$E$65536 = "the text you are
looking for","Found",""))


HTH

Paul

------------Original Message--------
So what I need to do is have a colum D that searches Sheet1, column E
for a certain text string entered in a different sheet (either 2 or 3)
column D. If they match I want the cell in column E, sheet 2 or 3 to
return a text of "Found" and if there is no match I want the cell to be
blank.

I've been looking in these forums and have a feeling it can be done, I
just can't figure out how.

Thanks.

 

[Peo Sjoblom]

One way

=IF(COUNTIF(Sheet1!$E$1:$E$65536,Sheet2!D3),"Found","")