jamiejohn187
New Member
- Joined
- Dec 4, 2017
- Messages
- 6
Hi guys,
I need to essentially vlookup product codes on one spreadsheet to see on a particular date what they were sold for.
Here is an odd breakdown of my issue:
<tbody>
</tbody>
So on Sheet 2 I need to return the price in column C of the price on Product for a specific date where only the date range is given in sheet 1.. Any help you can provide would be monumental.
Thanks!
I need to essentially vlookup product codes on one spreadsheet to see on a particular date what they were sold for.
Here is an odd breakdown of my issue:
Sheet 1 | ||||
Product | Price | Date Started | Date Finished | |
XYZABC | 19.99 | 01/10/2017 | 04/10/2017 | |
XYZABC | 25.99 | 05/10/2017 | ||
XYZABC | 32.99 | 11/09/2017 | 30/09/2017 | |
ABCXYZ1 | 11.99 | 01/10/2017 | 04/10/2017 | |
ABCXYZ1 | 5.99 | 05/10/2017 | ||
ABCXYZ1 | 6.99 | 11/09/2017 | 30/09/2017 | |
Sheet 2 | ||||
Product | Sold Date | Price | ||
XYZABC | 03/10/2017 | |||
XYZABC | 06/10/2017 | |||
XYZABC | 13/09/2017 | |||
ABCXYZ1 | 02/10/2017 | |||
ABCXYZ1 | 20/09/2017 | |||
ABCXYZ1 | 01/11/2017 |
<tbody>
</tbody>
So on Sheet 2 I need to return the price in column C of the price on Product for a specific date where only the date range is given in sheet 1.. Any help you can provide would be monumental.
Thanks!