| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
How do you perform a two-column lookup?
Assuming your headers are in row 1 and the data in A2:C6, use
SUMPRODUCT with double unary operators, comme ca: =SUMPRODUCT(--($A$2:$A$6=13),--($B$2:$B$6="CA"),$C$2:$C$6) This link http://groups.google.com/group/micro...6bd4f93886f512 ....explains the --, which is called a double unary operator. Very cool stuff. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2 Column Data lookup | Excel Discussion (Misc queries) | |||
| Column Lookup | Excel Discussion (Misc queries) | |||
| Lookup last entry in column | Excel Discussion (Misc queries) | |||
| Lookup then Match and insert value from next column | Excel Worksheet Functions | |||
| How to lookup data in a row and column | Excel Discussion (Misc queries) | |||
Threaded Mode
