cybermatrix
New Member
- Joined
- Jun 2, 2010
- Messages
- 37
How can I get all the values from one worksheet to another one if it matches the value I'm looking for? Vlookup only provides the first time it finds it. I have looked at index and match functions. Seems to me it needs to combine vlookup, index and match to make this work. However, that I'm finding is I have to provide that given value to get all the values. I have also thought about a pivot table.
This is what I need. I have a WS that has a list of sku's with the date in the next column. The other WS has a list of the each sku and how many times it has been ordered. I need to know each date that sku has been ordered.
WS with all the sku's and the date it was ordered, over 20,000 rows
<tbody>
</tbody>
WS with how many times it was ordered and the Dates Ordered column needs to have each date it was ordered. Or it can add a column to be Ordered Date2, etc.
<tbody>
</tbody>
This might not be the best way to go about it, but it will give a good idea of the information I need to get.
Any suggestions and help would be appreciated.
This is what I need. I have a WS that has a list of sku's with the date in the next column. The other WS has a list of the each sku and how many times it has been ordered. I need to know each date that sku has been ordered.
WS with all the sku's and the date it was ordered, over 20,000 rows
Sku | Order Date |
803672 | 6/23/2014 |
260644 | 6/23/2014 |
524601 | 6/23/2014 |
B10107004 | 6/23/2014 |
B61350BY4 | 6/23/2014 |
403285 | 6/23/2014 |
B61350BY4 | 6/23/2014 |
B61350BY4 | 6/23/2014 |
645924 | 6/23/2014 |
633595 | 6/23/2014 |
<tbody>
</tbody>
WS with how many times it was ordered and the Dates Ordered column needs to have each date it was ordered. Or it can add a column to be Ordered Date2, etc.
SKU | Qty Ordered | Dates Ordered |
B08910003 | 16 | |
B41107006 | 15 | |
B61350BY4 | 13 | |
B32210477 | 12 | |
447685 | 10 | |
704495 | 8 | |
B06407535 | 8 |
<tbody>
</tbody>
This might not be the best way to go about it, but it will give a good idea of the information I need to get.
Any suggestions and help would be appreciated.