Returning a list based on cell value

[badtangent]

I know in some forms this has been discussed, but I have not been able to find threads directly applicable. I would like to return a list (or array) to a single cell (such as A10) based on the value in another cell (A8). A8 does not/will not contain a value in the returned list, so VLOOKUP or the like will not help that I can tell. I was hoping it was as simple as using

=IF(A8="text", returned_list, "")

but of course this doesn't work. I can manage the IF/THEN portion, but getting the list to show up in the cell is where I'm stuck. Apologies in advance for my lack of skill....

[daffodil11]

I'd recommend the use of a UDF to accomplish a concatenation of all ranges in your list, otherwise you'll need some form of many successive functions to concatenate them manually.

Please Login or Register  to view this content.

[badtangent]

Worked like a charm. Much obliged!