match formula?!

[splash1980]

Dear all,

Please help me. I need formula to find text in within text (ex. cat) from sheet 2 and match the cat's color brown to sheet 1, etc.

sheet 1
____A_________B
1 animal______ color
2 cat
3 dog
4 bird

sheet 2
____A________ B
1 animal______ color
2 dog_________ white
3 cat_________ brown
4 bird_________ yellow
<qtlend></qtlend>
I hope that you can understand what I am asking, as I didn't make myself that clear.

 

[Aladin Akyurek]

Dear all,

Please help me. I need formula to find text in within text (ex. cat) from sheet 2 and match the cat's color brown to sheet 1, etc.

sheet 1
____A_________B
1 animal______ color
2 cat
3 dog
4 bird

sheet 2
____A________ B
1 animal______ color
2 dog_________ white
3 cat_________ brown
4 bird_________ yellow
<qtlend></qtlend>
I hope that you can understand what I am asking, as I didn't make myself that clear.

In Sheet1, B2 enter and copy down:

=INDEX(Sheet2!$B$2:$B$4,MATCH(A2,Sheet2!$A$2:$A$4,0))

 

[shadyshawn]

thought you were looking for something else.

 

[splash1980]

In Sheet1, B2 enter and copy down:

=INDEX(Sheet2!$B$2:$B$4,MATCH(A2,Sheet2!$A$2:$A$4,0))

Thank you so much! You saved my day!

 

[Aladin Akyurek]

Thank you so much! You saved my day!

You are welcome. Thanks for providing feedback.