Look up a value on dropdown list and return MULTIPLE values into another dropdown list.

Hello all,

I've been going crazy trying to figure this out.

On an Inventory sheet I have several squares with information based on different purchase orders: PO number, product type (3 options under this), product size (also 3 options, one for each product type), and case count (3 options as well).
In another sheet (Production Schedule) I'd like to select those POs from a drop down list and on following cells in same row populate a drop down list with the 3 product types (PT), product sizes (PS) and case count (CC) based on the PO that I selected initially from my dropdown.
Of course I cannot select VLOOKUP because it only returns one value, while here I need up to 3 values on each drop down list (it could be 2 or 1 sometimes).

My goal is to find (and learn) a formula to do this, but VGA is fine IF is the only option.

The POs on the Inventory sheet are not fixed, they will change every week, so everything is dynamic.

So far I was able to filter on another sheet the PT, PS and CC together in columns and also rows. By doing that I was able to sort them up an additional list without blank (I would hate to have drop list with blanks).

Hopefully someone can help,

Thanks

Attach a workbook. Go into advanced > Manage attachments > Upload your file > Close the window > Submit reply

Thanks for the tip on how to attach.

Here's the attachment.

Thank you!

Hi


By organizing your data as it shows in the file, I think you will have lots of problems to solve.

I think you mix the data with the presentation of the same data, namely when you join cells or when you group data into blocks instead of using simple tables.

My suggestion is that unless you have a better opinion, you should rethink the problem to avoid further difficulties.

Good luck.

Originally Posted by José Augusto

Hi


By organizing your data as it shows in the file, I think you will have lots of problems to solve.

I think you mix the data with the presentation of the same data, namely when you join cells or when you group data into blocks instead of using simple tables.

My suggestion is that unless you have a better opinion, you should rethink the problem to avoid further difficulties.

Good luck.

Hi,

Thanks for the suggestion but the organization of the data is not an issue as I was able (as show on first tab) to get the results I wanted but in a array formula - one result per cell.
My issue is lack of knowledge into placing those same results into a drop down list, not organization.

Thanks.