SOLVED

# Vlookup to reference weekly sales

Copper Contributor

# Vlookup to reference weekly sales

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

6 Replies

# Re: Vlookup to reference weekly sales

You need FILTER() function.

# Re: Vlookup to reference weekly sales

@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

# Re: Vlookup to reference weekly sales

Can you show some sample data and desired result?

# Re: Vlookup to reference weekly sales

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

best response confirmed by Mikeyh146 (Copper Contributor)
Solution

# Re: Vlookup to reference weekly sales

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)

# Re: Vlookup to reference weekly sales

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

Accepted Solutions
best response confirmed by Mikeyh146 (Copper Contributor)
Solution

# Re: Vlookup to reference weekly sales

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)