# 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.
###### 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.

Author 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
Commented:
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
Commented:
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