Hi,

One possiblility is,

=SUMPRODUCT((A2:A4=E2)*(B2:B4=F2)*(C2:C4))/SUMPRODUCT((A2:A4=E2)*(B2:B4=F2))

The formula assumes that columns A, B, and C contain the source data, E and
F contain the search criteria, and G would return the output (date). It will
account for duplicate entries.

Regards,
B. R. Ramachandran


"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