Find SKU price from a history of prices if i know the sales date

Jeffrey Green

Well-known Member
Joined
Oct 24, 2007
Messages
1,017
i have a list of SKU's on Sheet 1.
I have historical pricing on sheet 2 by SKU and price date.
I am trying to "vlookup or Index/Match, etc to bring in the historical price into sheet 1 that is immediately prior to sales date on Sheet 1

I can NEVER get this right . . .

thanks
 

FDibbins

Well-known Member
Joined
Feb 16, 2013
Messages
6,723
If you want to bring back the SKU price based on the SKU date,you wont be able to use vlookup - the search criteria needs to be in the very 1st column of the range.
Because you need to test for 2 things - SKU and Date, try this
A​
B​
C​
D​
E​
F​
G​
1​
Sheet1Sheet2
2​
SKUDatePriceSKUPRICEDATE
3​
123​
6/21/2018​
50​
123​
10​
6/1/2018​
4​
234​
20​
6/6/2018​
5​
345​
30​
6/11/2018​
6​
456​
40​
6/16/2018​
7​
123​
50​
6/21/2018​
8​
234​
60​
6/26/2018​
9​
345​
70​
7/1/2018​
10​
456​
80​
7/6/2018​
B3 would contain your selected date
C3=INDEX($F$3:$F$10,MATCH(A3&" "&B3,INDEX($E$3:$E$10&" "&$G$3:$G$10,0),0))
 

Forum statistics

Threads
1,085,513
Messages
5,384,107
Members
401,881
Latest member
Dato

Some videos you may like

This Week's Hot Topics

Top