Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Array with multiple selection criteria
I have a 3 column list. Two columns have criteria which must be true in order
to select the value of the third (numeric) column. For example: Sheet 1 Col 1 Col2 Amount CF AMI 1000.00 CI AMI 230.00 CF BLV 1500.00 CI BLV 160.00 I want to insert these values in a separate sheet, according to my selection rules, for example: Sheet 2 Cell A6 If column 1 = CF and column 2 = AMI insert contents of column 3 Cell A7 If column 1 = CF and column 2 = BLV insert contents of column 3 Cell B6 If column 1 = CI and column 2 = AMI insert contents of column 3 Cell B7 If column 1 = CI and column 2 = BLV insert contents of column 3 This is a very simple query, but my issue is that I am not sure if I should use a lookup or a nested IF statement, or if there is another function that I should use instead. Please advise. -- Robert Robinson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Criteria for lookup array | Excel Worksheet Functions | |||
MODE fx in array using multiple criteria | Excel Worksheet Functions | |||
Can I use an array formula with multiple criteria in the same row? | Excel Worksheet Functions | |||
Array Formulas with multiple criteria in the same row? | Excel Worksheet Functions | |||
SUMIF MULTIPLE ARRAY CRITERIA | Excel Worksheet Functions |