rainydaze999
New Member
- Joined
- Jan 7, 2014
- Messages
- 2
Hello,
I have a VLOOKUP problem which involves tracking price changes for a cost of goods calculation in a spreadsheet used to track sales, revenues, and profits. Each item sold has a unique ID number. I need to track cost data & take price changes into account within the VLOOKUP (or other) function. Sales data & calculations in question are in one tab of the Excel 2013 Workbook. Cost data is in another tab of the same Excel Workbook.
Each purchase I make contains the following information: Item ID#, Item Description, Item Cost, Date of Purchase. Each purchase is represented in a row. What I need to do is to return Item Cost for an Item ID# when the Date of Sale is less than or equal to Date of Purchase. If multiple rows which match Item ID and the Date of Purchase is less than the Date of Sale, the row with the latest Date of Purchase should be returned.
Each sale contains Item ID#, Item Description, Date of Sale.
Can anyone provide advice on the Excel syntax for this function?
Thanks in advance!
I have a VLOOKUP problem which involves tracking price changes for a cost of goods calculation in a spreadsheet used to track sales, revenues, and profits. Each item sold has a unique ID number. I need to track cost data & take price changes into account within the VLOOKUP (or other) function. Sales data & calculations in question are in one tab of the Excel 2013 Workbook. Cost data is in another tab of the same Excel Workbook.
Each purchase I make contains the following information: Item ID#, Item Description, Item Cost, Date of Purchase. Each purchase is represented in a row. What I need to do is to return Item Cost for an Item ID# when the Date of Sale is less than or equal to Date of Purchase. If multiple rows which match Item ID and the Date of Purchase is less than the Date of Sale, the row with the latest Date of Purchase should be returned.
Each sale contains Item ID#, Item Description, Date of Sale.
Can anyone provide advice on the Excel syntax for this function?
Thanks in advance!