vlookup depending on two values

[Afarag]

Dears,

i ask for how can i match date depending on two values
i have 3 columns for username, date and value
i want to get the value that match the username and date together

Gratefully,

 

[json]

i tried using some helper columns (one that combined the name & Date columns for each 'table'), but your 2 date columns are not formatted the same way and therefore, cause Excel to see them as different values...


if you address this you can add a new col A with =B2&C2 to combine the name&Dates of the first list, then in K2 enter: =VLOOKUP((G2&I2),$A$2:$E$377,5,FALSE)

 

[vijay.vizzu]

Dear Afaraq

If you change date formate, then below will work for you
=SUMPRODUCT((A2:A377=F2)*(B2:B377=H2),D2:D377)

 

[Balli]

Dear Afarag,

You can try this array formula also:

=INDEX($D$2:$D$377,(MATCH(F10&(TEXT(H10,"M/D/YYYY")),$A$2:$A$377&$B$2:$B$377,0)))