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
Bookmarks