I have a worksheet in which I'm trying to extract certain values from List A (which DOES contain empty rows), but only those values which appear in another list of values (List B). Here is an example:
List A:
chihuahua
great dane
labrador retriever
siamese
tabby
terrier
List B:
akita
chihuahua
collie
great dane
irish setter
labrador retriever
rottweiler
terrier
weimeraner
Is there a formula/macro/etc I could use which would return the following:
chihuahua
great dane
labrador retriever
terrier
Thank you in advance for your assistance!
Bookmarks