Lookup with multiple criteria... please help!
I'd use a pivot table for this.
"anna" wrote:
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
|