one way to do it if the multiple entries are identical
set up a helper column just befor the date column
and use the formula
=name & Group
Do your vlookup for the concatinated value and it will return the first match

"Jon C" wrote:

Hi,

I'm trying to use Vlookup to select a value based on two criteria but to no
avail.

E.g.

Name Group Date
Jon Dev 1/2/2005
Jon Test 6/3/2005
Fred Dev 4/1/2005

Id like to be able to search on Name and Group and return the date. Id
normally use SumProduct however as the date is numeric, if there are multiple
entries the same it of course sums them€¦.!

TIA,

Jon C