Hello All,
I have problem with creating a new table with correctly sorted data. Here's the issue:
I have two tables with data, first one has a columns named: "product" and "date". It has the dates related to the product. I have also other table (in another sheet) with columns: "product" and "sub-product". In this table we have sub-products assigned to the products (please see the image attachment). I would like to create a table which would change the cells with products into sub-products assigning the corresponding date just like in the image i've attached.
I've tried with vlookup but unfortunately it returns only one value. I've also tried with the 'match' function but It didn't work.
Could you please advise how can I manage this?
https://gyazo.com/d45571e53d99f963bfd06a946d079132
I have problem with creating a new table with correctly sorted data. Here's the issue:
I have two tables with data, first one has a columns named: "product" and "date". It has the dates related to the product. I have also other table (in another sheet) with columns: "product" and "sub-product". In this table we have sub-products assigned to the products (please see the image attachment). I would like to create a table which would change the cells with products into sub-products assigning the corresponding date just like in the image i've attached.
I've tried with vlookup but unfortunately it returns only one value. I've also tried with the 'match' function but It didn't work.
Could you please advise how can I manage this?
https://gyazo.com/d45571e53d99f963bfd06a946d079132
Last edited by a moderator: