This forum has helped me a lot in the past. I tried searching and could not find an answer on this, and I fully admit that it could be because I'm using the wrong search terms. I will describe what I want to do as best I can.
I want to have a list of characteristics which would lie in rows. For example:
Has 4 legs.
Has 2 eyes.
Has fur.
Has a tail.
Has fins.
Then I want to be able to select just the rows that apply to my "subject." Like this:
x Has 4 legs.
Has 2 eyes.
x Has fur.
x Has a tail.
Has fins.
In my mind, I would organize the characteristics in column B so that column A would be available to put an "x" next to the characteristics that apply to my subject.
Finally--and this is where the formula comes in--I need a formula that will check the rows where I have placed an "x" and aggregate the corresponding characteristics into A SINGLE STRING. I feel that is the difference for what I'm trying to do and VLOOKUP. So, the formula would produce this string from my example:
Has 4 legs. Has fur. Has a tail.
Any ideas?
Bookmarks