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
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...