formula
 

i have this chart:
column A column B columnn C
unit# dept# new#
7112 101 725
7112 102 726
7112 103 727
7112 104 728
7112 105 729
7112 106 730
7113 101 311
7113 102 312
7113 103 313
7113 104 314
7113 105 315
7113 106 316
6880 101 725
6880 102 312
6880 103 313
6880 104 314
6880 105 729
6880 106 730
on sheet2, i have a combination of numbers of col A and B (e.g. 6880 101) i
need a formula that based on this "combination" returns the value that is in
column C. is it possible? thanks in advance

One way:

As long as the column C values are numeric:

=SUMPRODUCT(--(Sheet1!A1:A1000=6800),--(Sheet1!B1:B1000=101),
Sheet1!C1:C1000)


In article ,
Armando Martellini
wrote:

i have this chart:
column A column B columnn C
unit# dept# new#
7112 101 725
7112 102 726
7112 103 727
7112 104 728
7112 105 729
7112 106 730
7113 101 311
7113 102 312
7113 103 313
7113 104 314
7113 105 315
7113 106 316
6880 101 725
6880 102 312
6880 103 313
6880 104 314
6880 105 729
6880 106 730
on sheet2, i have a combination of numbers of col A and B (e.g. 6880 101) i
need a formula that based on this "combination" returns the value that is in
column C. is it possible? thanks in advance

JE, thanks alot, a little change in your formula and it woorked great

"JE McGimpsey" wrote:

One way:

As long as the column C values are numeric:

=SUMPRODUCT(--(Sheet1!A1:A1000=6800),--(Sheet1!B1:B1000=101),
Sheet1!C1:C1000)


In article ,
Armando Martellini
wrote:

i have this chart:
column A column B columnn C
unit# dept# new#
7112 101 725
7112 102 726
7112 103 727
7112 104 728
7112 105 729
7112 106 730
7113 101 311
7113 102 312
7113 103 313
7113 104 314
7113 105 315
7113 106 316
6880 101 725
6880 102 312
6880 103 313
6880 104 314
6880 105 729
6880 106 730
on sheet2, i have a combination of numbers of col A and B (e.g. 6880 101) i
need a formula that based on this "combination" returns the value that is in
column C. is it possible? thanks in advance