Extremely Vlookup, help me pls, ths much

V

vumian

The Table will be filled filled
Item LT LH LC
3150169 ? ? ?
3150173 ? ? ?
3150175 ? ? ?
3150171 ? ? ?
3150415 ? ? ?
3160142 ? ? ?

This is a Array Table with multi Criteria
Item Date Criteria Value
3150169 17/07/06 LT 1000
3150173 17/07/06 LH 1500
3150173 18/07/06 LH 2250
3160142 17/07/06 LH 247
3160142 18/07/06 LC 498
3160521 17/07/06 LC 254
3160521 18/07/06 LC 457

- Cells contain ? Will be get col 4 at Array Table
- If Two or multi Item same, The Value will be sum
- Ex: Item: 3150173 has 2 different date, However, Value col must b
sum: 375
 
V

vezerid

Hi,
assuming the array table is in sheet named Source. The formula you
should put in B2 is:

=SUMPRODUCT('Source'!$D$2:$D$100*('Source'!$A$2:$A$100=$A2)*('Source'!$C$2:$C$100=B$1))

Copy down and accross as far as necessary.

HTH
Kostis Vezerides
 
V

vumian

Sorry, i fail to understand your mean, Could you be more specific more
!
May you do it in Sheet, in oder to me clear well.

It's very neccessary for me, pls pls help me

thank you.
 
Top