you can do that with a sumproduct function - note you will get the sum of all
matches of the two criteria.

with your data in a2:d5 and desired id in a7, desired date in b7, this does
"lookup" on column C

=SUMPRODUCT((A2:A5=A7)*(B2:B5=B7)*(C2:C5))

"Nav" wrote:

I have a list of data (2 sets) , I need the data to be picked up from from 1
set if the Customer ID and the Date of purchase match together. I am aware
VLOOKUP will match and lokkup if one of the sets of data agrees, but is it
possible to pick up the 4th column if the customer ID AND the date match from
the first data set to the second data set? Please can someone help. Thanks
in advance.

EG.
Data set 1
ID Date Qty Total
1 1/12/05 5 1500
1 3/12/05 5 1500
2 2/12/05 10 2500

Data set 2
ID Date Total
1 3/12/05 (= formulae required to match both ID and date as
criteria.)