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

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

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

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.