Vlookup to reference weekly sales

[Mikeyh146]

Hello,

I am using a drop down list to select dates for viewing my weekly sales.

I am then using a VLOOKUP to find me the results, in the table next to it I was it to reference a week before to show a comparison of this week vs last.

can I do a VLOOKUP or something, that if this cell is referenced then reference the cell above?

thanks 

M

[#2]

You need FILTER() function.

[#3]

@Harun24HR can you filter by a cell before? I tried filter but it just shows me the results. 

basiclly I want to select a week from my list, and then it populates the sales for that week, but when those cells populate I want it to select the week before in the column next to it for a comparison, 

so like this 

list of dates  

sales data here populated by list | sales data here populated by the week before the selected week in the list

[#4]

Can you show some sample data and desired result?

[#5]

Sorry should have started with this.

Attached are screen grabs from my excel, 

I have drawn the flow of how I want it to go. 

 Select date > Fills cells > when cells fill it fills the other cells but 1 date before

@Harun24HR 

[#6 · Accepted solution]

@Mikeyh146 

VLOOKUP is a bit more direct but if you need to pull previous date's revenue, you can use INDEX-MATCH for both:

Current:

=INDEX(Sheet2!$D$1:$D$21,MATCH($B$5,Sheet2!$C$1:$C$21,0))

Previous:

=INDEX(Sheet2!$D$1:$D$21,MATCH($B$5,Sheet2!$C$1:$C$21,0)-1)

[#7]

thank you this worked perfectly, I don't know why I didn't think of index match, thank you