ok been stuck all morning, time to ask for help...
(columnB is empty = insert formula in B2 and copy down)
columnA columnB columnC
catseat -------- dog
adogssnores ---- rat
birdsfly --------- cat
haterats
If columnA A2 contains any element from columnC (not exact just includes the phrase = c4 cat is included in a2 so b2 would include the word 'cat') = then the data matching in columnC will be returned to columnB.
Here's where i'm at with the formula:
=IF(SUMPRODUCT(--(ISNUMBER(SEARCH(Table1[Column3],A2,1)))),"FOUND","")
This returns the following in columnB which is correctly identifying the 'found' rows:
B2 = FOUND
B3 = FOUND
B4 =
B5 = FOUND
BUT would like to show the following in columnB (desired answer to question - how to?)
B2 = CAT
B3 = DOG
B4 =
B5 = RAT
Any advice would be greatly appreciated as been stuck on this all morning and could really use a hand...
Bookmarks