I was wondering if someone could help me to return multiple numbers based on a lookup value. I have a unique SKU (column F), but there are multiple purchase order (PO) numbers associated with it (column J).
What I am trying to get is, based on the SKU number, it would give me all the PO’s related to it in one cell (I.e. see cells F17:G18). The values can be returned in one cell together, or over multiple columns. Is this possible? Right now I put the data into a pivot table, one column has the SKU, and another one has multiple POs, but then I have to transpose the data manually.
Reply With Quote