USING VLOOKUP AND HLOOKUP
Say your datalist was in C1 to H4.
C1 and D1 are empty, as in your example.
Try this:
=SUMPRODUCT((C2:C4=B1)*(D2:D4=B2)*(E1:H1=B3)*E2:H4 )
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Glenn" wrote in message
...
I NEED TO BE ABLE TO SET A FORMUAL TO DO THE FOLLOWING:
B1=3,B2=21,B3=16
i WANT TO TAKE THESE RESULTS FROM A LIST TO PRINT THE RESULTS.
THE LIST IS LIKE:
15 16 17 18
3 20 $10 $20 $30 $40
3 21 $15 $25 $35 $45
3 22 $16 $17 $18 $19
i WANT TO BE ABLE TO FIND 3 , 21 , 16 AND PRINT THE RESULT.
THE EXAMPLE THE RESULT IS $25
|