Closest Date ad Price - 2.xlsx
I'm usually pretty good with Excel but this one has me stumped.
What I am trying to do is based on a SKU and its Return date match bring back the closest sale date and the sale price of the SKU on that closest date.
Figuring an Index Match formula would be best however the issue I'm coming up against is that the date is trying to find an exact match.
I have also tried maliplulating vlookup formulas to no avail.
Column A shows the SKU
Column B shows the Date Sold
Column C shows the Sales Price
Column E Shows the SKU needing to be looked up
Column F Shows the return date
Column G I would like to return the closest date to the return date that the SKU in column E shows
Column H I would like to return the price of the SKU on the closest date on column G
I know this can be done, I'm just having trouble executing this one. Any help would be greatly appreciated.
Sample Attached
Bookmarks