using excel to look up data

wiredemc12
wiredemc12 used Ask the Experts™
on
I have data that I would like to extract from another tab. The problem I have is there is characters in front of both sets of data. Is there a way to create a formula that will find the lookup even though there is miscellaneous data?
EX: I use Cow, Dog and Cat.
Sheet 1:
abdcdfeCowabcda
abdfddfDogadwfl
vfaewCatwqlul

Sheet 2                                                                                      Column that i want to pull from
datadddcow some more data                                               a
dataddddddDog some more data                                        b
datadddaCat some more data                                               c
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2015

Commented:
I'm assuming this is what you are looking for..check sheet2 where i created what you are looking for and sheet1 i'm picking up values of the match..

Saurabh...
Lkupvalue.xlsx

Author

Commented:
the only problem is my lookup values on sheet 1 have data in front of them. For example ddddCow.
Top Expert 2015
Commented:
Okay and then how do you make out which word to look for if has the data in front of it??

Saurabh...

Author

Commented:
This was a long shot.  You are right there is not a way to look this up. I appreciate you helping me. I have to go back to the drawing board.
Top Expert 2015
Commented:
In plain short terms if you can't define a logic for identify the word you either need to do the manner which i did or you can't do it from program if it can't be defined in logics and it's subjective in nature and changes every time..

Saurabh...

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial