K
krayziez
A1:
cat
A2: cat1 B2: feline1
A3: dog1 B3: canine1
A4: cat2 B4: feline2
A5: dog2 B5: canine2
A6: dog3 B6: canine3
A7 should be formula to return all values on column B that matches th
range of A2:A6 given A1 value
Right now, all I can do is do a match for all items containing "cat" o
A1:
=ISNUMBER(MATCH("*"&A1&"*",A2:A6,0))
Is there a way of returning the value of B column for the correspondin
A column (same row)?
Ultimately, I'd like cell A7 to look like this:
feline1, feline2
I hope I can do this without programming. I'm sure I can with a comb
of match and vlookup
cat
A2: cat1 B2: feline1
A3: dog1 B3: canine1
A4: cat2 B4: feline2
A5: dog2 B5: canine2
A6: dog3 B6: canine3
A7 should be formula to return all values on column B that matches th
range of A2:A6 given A1 value
Right now, all I can do is do a match for all items containing "cat" o
A1:
=ISNUMBER(MATCH("*"&A1&"*",A2:A6,0))
Is there a way of returning the value of B column for the correspondin
A column (same row)?
Ultimately, I'd like cell A7 to look like this:
feline1, feline2
I hope I can do this without programming. I'm sure I can with a comb
of match and vlookup