May 03 2021 10:02 PM
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!
May 04 2021 02:03 AM - edited May 04 2021 02:04 AM