Hi gurus.. i"ve been trying to match a pruduct/size/brand/date-rage with a table with the same data plus the price. I tried matchin, indexing, vlookup but i have not been able to do it, Any tips?
Table1
sale date- Product- Size- Brand
9/12/2012- Shirts- medium- BrandA
12/5/2012- Shirts- medium- BrandA
5/8/2013 - Shirts- medium- BrandA
9/5/2013 - Shirts- medium- BrandA
9/12/2012- Shirts- medium- BrandB
12/5/2012- Shirts- medium- BrandB
5/8/2013- Shirts- medium- BrandB
9/5/2013- Shirts- medium- BrandB
Table 2
Product- Size- Brand- Star_date- End_date - Price
Shirt- medium- BrandA- 9/11/2012 12/3/2012 2.55
Shirt- medium- BrandA- 12/4/2012 3/14/2013 2.45
Shirt- medium- BrandA- 3/15/2013- 4/29/2013- 2
Shirt- medium- BrandA- 4/30/2013- 5/6/2013- 2.65
Shirt- medium- BrandA- 5/7/2013- 5/12/2013- 2.35
Shirt- medium- BrandA- 5/13/2013- 9/3/2013- 2.25
Shirt- medium- BrandA- 9/4/2013- 9/3/2099- 1.9
Shirt- medium- BrandB- 9/11/2012- 12/3/2012- 2.8
Shirt- medium- BrandB- 12/4/2012- 2/18/2013- 2.7
Shirt- medium- BrandB- 2/19/2013- 3/14/2013- 2.45
Shirt- medium- BrandB- 3/15/2013- 4/29/2013- 2.6
Shirt- medium- BrandB- 4/30/2013- 5/6/2013- 2.77
Shirt- medium- BrandB- 5/7/2013- 5/12/2013- 2.66
Shirt- medium- BrandB- 5/13/2013- 5/12/2099- 2.35
Bookmarks