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

%3CLINGO-SUB%20id%3D%22lingo-sub-2320269%22%20slang%3D%22en-US%22%3EFinding%20a%20date%20minus%201%20year%20then%20giving%20the%20value%20in%20next%20column.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2320269%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20several%20columns%20but%20the%20first%20column%20has%20dates%2C%20the%20second%20is%20the%20number%20of%20units%20sold%20up%20to%20that%20date.%26nbsp%3B%20These%20dates%20are%20from%20last%20year.%26nbsp%3B%20I%20would%20like%20to%20find%20the%20number%20of%20units%20sold%20up%20to%20the%20date%20one%20year%20ago.%3C%2FP%3E%3CP%3EThe%20closest%20that%20I%20have%20got%20is%3A%3C%2FP%3E%3CP%3E%3DVLOOKUP(MAX(A4%3AA300)%2CA3%3AB300%2C2%2CFALSE)%3C%2FP%3E%3CP%3Ethis%20gives%20me%20the%20total%20number%20units%20sold%20last%20year%2C%20not%20to%20date%20minus%20a%20year.%3C%2FP%3E%3CP%3EI'm%20close%20but%20not%20close%20enough.%3C%2FP%3E%3CP%3EI%20appreciate%20any%20help%20at%20all.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2320269%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2320882%22%20slang%3D%22en-US%22%3ERe%3A%20Finding%20a%20date%20minus%201%20year%20then%20giving%20the%20value%20in%20next%20column.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2320882%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1044285%22%20target%3D%22_blank%22%3E%40Kiley880%3C%2FA%3E%26nbsp%3BPerhaps%20like%20this%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-05-04%20at%2011.02.16.png%22%20style%3D%22width%3A%20468px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F277796i7D7407F568DB5B75%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-05-04%20at%2011.02.16.png%22%20alt%3D%22Screenshot%202021-05-04%20at%2011.02.16.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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