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 2 Column that i want to pull from
datadddcow some more data a
dataddddddDog some more data b
datadddaCat some more data c