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.
rbminchewAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

rbminchewAuthor Commented:
This is the formula I tried
=MAX(VLOOKUP(R2,$A$1:$N$57,12,FALSE))

as well as
=VLOOKUP(R2,$A$1:$N$57,MAX(L2:L50),FALSE)
0
ildcCommented:
Hi,
Wouldn't this do the trick:?
=VLOOKUP(MAX(L2:L50),$A$1:$N$57,12,FALSE)

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,
iLDC
0
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"

=MAX(IF(A$1:A$57=R2,L$1:L$57))

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
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
rbminchewAuthor Commented:
Perfect!!
Thank you both for the answer
I do appreciate your time.
Have a great day!!  :)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.