Use datafilterautofilter
or look in the help index for MATCH to find the first and last match
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"klh84" wrote in message
...
Is there a way to use one function to lookup two values under the same
unique
ID.

EX:
Account Value
55 20
55 50

I was hoping to find a way to write a vlookup for this that would pull in
the 20, and then also be able to pull in the 50 as well in the same
function.
Is this possible?