Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I have a multi what if:
Sheet A:
If A7 can be found in Sheet 3 Column A and C12 can be found in sheet 3 Column 2 then give me the corresponding result in 3. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I have a multi what if:
=IF(ISNUMBER(MATCH(1,(Sheet3!A2:A200=A7)*(Sheet3!B 2:B200=C12),0)),INDEX(Sheet3!C2:C200,MATCH(1,(Shee t3!A2:A200=A7)*(Sheet3!B2:B200=C12),0)),"")
which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. Excel will automatically enclose the formula in braces (curly brackets), do not try to do this manually. When editing the formula, it must again be array-entered. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "missikay03" wrote in message ... Sheet A: If A7 can be found in Sheet 3 Column A and C12 can be found in sheet 3 Column 2 then give me the corresponding result in 3. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Complex Multi-condition, multi-workbook count | Excel Discussion (Misc queries) | |||
match in multi-column and multi-row array | Excel Discussion (Misc queries) | |||
how can I paste multi-line/multi-paragraph data into ONE cell? | Excel Discussion (Misc queries) | |||
Multi-If function | Excel Worksheet Functions |