ExcelBanter - Multiple lists in a cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Multiple lists in a cell (https://www.excelbanter.com/excel-worksheet-functions/257284-multiple-lists-cell.html)

Xman

Multiple lists in a cell

Is it possible to have a list range in one cell based on the inputed
information in that cell? IE, I have a packing list for 3 different
products, and 3 different master lists. On the 1st list, I have added in
list form in one cell the 3 different lists I could possibly generate. Is it
possible to change a list reference in the same cell based on the list I want
to generate?
--
JARoman

Eduardo

Multiple lists in a cell

Hi,
I think you need dependent list see Debra web

http://www.contextures.com/xlDataVal02.html

"Xman" wrote:

Is it possible to have a list range in one cell based on the inputed
information in that cell? IE, I have a packing list for 3 different
products, and 3 different master lists. On the 1st list, I have added in
list form in one cell the 3 different lists I could possibly generate. Is it
possible to change a list reference in the same cell based on the list I want
to generate?
--
JARoman

All times are GMT +1. The time now is 03:32 PM.