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
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
Last Comment
Saurabh Singh Teotia
ASKER
the only problem is my lookup values on sheet 1 have data in front of them. For example ddddCow.
ASKER CERTIFIED SOLUTION
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.
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.
SOLUTION
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.
Saurabh...
Lkupvalue.xlsx