Double post >>> find and display

[tweety127]

hi,

is there a function that will return the specific content of the cell. like for example, i have a cell that contains the word DOG(a1), and on the other one is a sentence like THEDOGBARK(b1)...the function must find the word dog and must put it in another cell(c1).

find (a1) to (b1) and display the word in (c1)...

ex1.
a1 = dog
b1 = thedogbark
c1=dog

ex2.
a1=bark
b1 = thedogbark
c1=bark

ex3.
a1=the
b1 = thedogbark
c1=the

THANKS SO MUCH IN ADVANCE

[oldchippy]

Try this in D1

=IF(ISERR(MID(A1,FIND("dog",A1,1),3)),"",MID(A1,FIND("dog",A1,1),3)) copy across to column F

[tweety127]

the lookup values changes and is not fixed.

[oldchippy]

If you copy it across from D-F, you will get dog in each cell if they appear in any of cells A-C

[tweety127]

i got it, now, what if, i have this range of words that needs to find a match in a cell.

ex: a1 = thedogbarkatthecat

and the lookups will be:

b1=dog
b2=rat
b3=nice
b4=good

again, each cell values varies...

the matching word (from the lookups) on cell a1 must be returned to cell c1.

[oldchippy]

The format of your question has changed so in C1

=IF(ISERR(MID($A$1,FIND(B1,$A$1,1),3)),"",MID($A$1,FIND(B1,$A$1,1),3)) copy this down to C4

[tweety127]

im very sorry if i am taking too much of your time and for the confusion as well, i really need to setup this template for my reports and will be of great help to me....please bear with me...thanks so much

please see attached for the details

[oldchippy]

Hello there,

It would be better if you could provide a small zipped sample of your worksheet, it would be easier to follow.

To post a zipped example, go to “My Documents” or wherever you have your file stored, right-click and “Send to > Compressed file”, then attach this to your post.

[tweety127]

please see attached

[tweety127]

i also attached my previous attempts on the actual sample report

thanks so much

[oldchippy]

Sorry tweety127,

Not grasping this one, can you explain in a bit more detail? May be I'm getting tired, I'm just about to "leave the desktop", be back tomorrow.