Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a worksheet with a list of results, such as...
Michael Tom Sue etc Num1 Num2 Results Num1 Num2 Results Num1 Num2 Results 1 0 5 1 0 7 2 0 10 2 0 11 .... ... ... ... ... ... 10 0 25 10 0 24 1 1 6 1 1 9 2 1 12 2 1 14 .... ... ... ... ... ... 10 1 27 10 1 26 Hopefully, you get the idea. On another worksheet, I need to display the results given the "name" and "num1" and "num2". The array references change with the "name" chosen AND there are two search criteria per name. Could anyone please help me out with the correct formula for this? Thanks so much! anna |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Get cell value with multiple criteria lookup | Excel Worksheet Functions | |||
Multiple Criteria in SumProduct, N/A Result | Excel Worksheet Functions | |||
Counting by multiple criteria | Excel Worksheet Functions | |||
Dynamic range names, multiple criteria, sumproduct | Excel Discussion (Misc queries) | |||
COUNTIF or SUM function (Multiple criteria) HELP!! | Excel Worksheet Functions |