Double Lookup

[Jason]

I have rows of data that look like the following. I
would like to use some sort of lookup function to pull
data from these rows:

FIN DATE COMPANY SALES NI ROE ROA
Q1 2003 Company A 10,000 689 12% 10%
Q4 2002 Company A 43,302 2,900 10% 9.5%
Q1 2002 Company B 8,500 398 8% 6%
"" ""


On another worksheet, I have the following setup for
which I would like to pull values from the above.

SALES NI
COMPANY Q4 2002 Q1 2003 Q4 2002 Q1 2003

Company A =43,302 =10,000 =2,900 =689

Is there some way that I can get some form of a lookup to
pull these values in the manner above?

 

[Mike]

A B C D E
1 SALES NI
2 COMPANY Q4 2002 Q1 2003 Q4 2002 Q1 2003
3 Company A 43,302 10,000 2,900 689
4

B3: =SUMPRODUCT((Sheet1!$B$2:$B$100=$A3)*(Sheet1!$A$2:$A$100=B$2)*(Sheet1!$C$2:$C$100))
Copy Cell B3 to C3.
D3: =SUMPRODUCT((Sheet1!$B$2:$B$100=$A3)*(Sheet1!$A$2:$A$100=D$2)*(Sheet1!$D$2:$D$100))
Copy Cell D3 to E3.

 

[JMay]

Mike Thanks for the solution. Sumproduct is obviouly the best solution; I
toyed with trying to solve this using the Index/Match combination - first to
see if it would work and second to better understand why it did or did not..
I've about decided that it will not work (that is using the Index/match) as
it seems the index/match go-at-it only works when you are working with
unique data (what I'd call a pure matrix - no repeating data) versus the
structure of this given source range which has repeating data in its rows
Company A (twice) etc...
Hope I'm making sense.. Can you comment?
TIA,

A B C D E
1 SALES NI
2 COMPANY Q4 2002 Q1 2003 Q4 2002 Q1 2003
3 Company A 43,302 10,000 2,900 689
4

B3: =SUMPRODUCT((Sheet1!$B$2:$B$100=$A3)*(Sheet1!$A$2:$A$100=B$2)*(Sheet1!$C$2:$
C$100))
Copy Cell B3 to C3.
D3: =SUMPRODUCT((Sheet1!$B$2:$B$100=$A3)*(Sheet1!$A$2:$A$100=D$2)*(Sheet1!$D$2:$
D$100))
Copy Cell D3 to E3.

news:[email protected]...