Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |