Posted to microsoft.public.excel.worksheet.functions
|
|
Array with multiple selection criteria
Hi,
Did you do the Ctrl+Shift+Enter
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"Robert Robinson" wrote in
message ...
Excel does not seem to like the D6:D9 and E6:E9 arguments...
--
Robert Robinson
"Ashish Mathur" wrote:
Hi,
You can use this array formula (Ctrl+Shift+Enter). I have assumed that
the
data below is in range D6:F9. D12 and E12 have CF and BLV
=INDEX($D$6:$F$9,MATCH(D12&E12,D6:D9&E6:E9,0),3)
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"Robert Robinson" wrote in
message ...
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
|