Finding a date minus 1 year then giving the value in next column.

Copper Contributor

I have several columns but the first column has dates, the second is the number of units sold up to that date.  These dates are from last year.  I would like to find the number of units sold up to the date one year ago.

The closest that I have got is:

=VLOOKUP(MAX(A4:A300),A3:B300,2,FALSE)

this gives me the total number units sold last year, not to date minus a year.

I'm close but not close enough.

I appreciate any help at all.

 

Thank you in advance!

1 Reply

@Kiley880 Perhaps like this:

Screenshot 2021-05-04 at 11.02.16.png

Screenshot 2021-05-04 at 11.04.08.png