Avatar of wiredemc12
wiredemc12
 asked on

using excel to look up data

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
Microsoft Excel

Avatar of undefined
Last Comment
Saurabh Singh Teotia

8/22/2022 - Mon
Saurabh Singh Teotia

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
wiredemc12

ASKER
the only problem is my lookup values on sheet 1 have data in front of them. For example ddddCow.
ASKER CERTIFIED SOLUTION
Saurabh Singh Teotia

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
wiredemc12

ASKER
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.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
SOLUTION
Saurabh Singh Teotia

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.