• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 466
  • Last Modified:

vlookup return greater date

need assistance with a vlookup formula to return the greater date in a table for a specific product that may have 5 dates listed in the table.  Please help.
  • 2
2 Solutions
rbminchewAuthor Commented:
This is the formula I tried

as well as
Wouldn't this do the trick:?

You use the max function to find the max date of a range
than use vlookup to find the info in the 12th column in the other range.

Kind regards,
barry houdiniCommented:
If column A has products and L has dates then you would find the largest date for a product in R2 with this "array formula"


confirmed with CTRL+SHIFT+ENTER

If you haven't used array formulas before then you need to follow this process to confirm with CTRL+SHIFT+ENTER:

Put formula in a cell, select that cell and press F2 to select formula. Now hold down CTRL and SHIFT keys and press ENTER. If done correctly then you will see curly braces like { and } around the formula in the formula bar

regards, barry
rbminchewAuthor Commented:
Thank you both for the answer
I do appreciate your time.
Have a great day!!  :)
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now