Vlookup does not deal well with multiple matches. Does your existing formula
return a number or Text. If it is a number we can look into using sumproduct.
If not things get difficult.
--
HTH...

Jim Thomlinson


"Shaun" wrote:

How would I add logic to this formula =VLOOKUP($A2,EXP,6,FALSE) so that it
returns the largest value if I have multiple matches in the table?