Searching a Differnt worksheet in the same workbook.

  • Thread starter Thread starter Creperum
  • Start date Start date
C

Creperum

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.
 
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
 
No, the row numbers don't need to match, it just needs to see if there
is a match present.

Thanks, I'm working on it now.
 
Back
Top