=sumproduct((Table2!A2:A6=$A2)*(Table2!B2:B6=B$1)* (Table2!C2:C6))
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"Daniel Collison" wrote in
message ...
Table 1 and Table 2 both contain a common vendor ID in column A. Table 2
contains caseload counts in column C associated with Client types in
column
B. In Table 1, columns B, I want to create a formula which will match the
value in column A with the same value in Table 2, column A. I then want
the
formula in table 1 to return the value in table 2, column C if the value
in
table 2, column B is €śclient type 1€ť. Any suggestions?
Table 1:
A B
Vendor Client Type 1
2 23
4
5 15
Table 2:
A B C
Vendor Client Type Caseload
2 Client Type 1 23
2 Client Type 2 42
4 Client Type 2 15
5 Client Type 1 15
5 Client Type 3 14