Nov 18 2022 03:59 PM - edited Nov 18 2022 04:36 PM
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
Nov 19 2022 02:48 PM
@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
Nov 20 2022 12:17 AM
Nov 21 2022 01:55 AM
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
Nov 22 2022 08:19 AM
SolutionVLOOKUP 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)
Nov 24 2022 12:48 AM
Nov 22 2022 08:19 AM
SolutionVLOOKUP 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)