Excel 2007 : Return all values based on 2 variables

[Aggie81]

I want to return a list of names into one cell based on 2 variables preferably separated by commas and spaces. Any help is appreciated.
Thanks,
Lee

[foxguy]

You will have to do a lot better job of explaining what you want. Where are the names coming from? Where are the 2 variables? Is this supposed to be a formula or a UDF() or what?

[Aggie81]

I have the variables in columns A and B with the list to return in column C to be returned to cell C40. I want to return a list of caladiums based on color and leaf shape. Column A has the colors designated by P,R,W, and Y for pink, red, white and yellow. Column B has the leaf shape with S for strap and F for fancy. Column C has the different variety names. I have formulas to show quantity, sales amount, average price and percentages based on color and leaf shape but wanted to list the varieties that made up each color and leaf shape.
Thanks,
Lee

[foxguy]

Hi Aggie81;

I think this can be done with a UDF(). I can write it for you. I would call it "ListVarieties". I would need a better description of the column contents, something like this:

Please Login or Register  to view this content.

You say you want the results in C40. What cells would contain the choice you want the List for?

Say you select a Color in C38, and you select a Shape in C39. Then in C40 you would enter the formula =ListVarieties(C38,C39). C40 would automatically change when you changed C38 or C39.

If that sounds like what you want, then provide a sample of your columns.