Looking Up Value Using 2 Criteria
 

My data looks like so:

SPY BOX549 48.70%
SPY BOX910 40.50%
SPY BOX913 5.10%
SPY BOX060 2.20%
SPY BOX980 1.20%
SPY BOX958 1.10%

QQQQ BOX549 33.00%
QQQQ BOX980 21.50%
QQQQ BOX912 16.60%
QQQQ BOX910 16.40%
QQQQ BOX913 5.80%

I have a another table that looks as so:

QQQQ BOX549
SPY BOX910

I would like to try a formula in c1 that will look at a1 and a2 and then
look at the table 1 and return the value in col c...for example

QQQQ BOX549 33.00%
SPY BOX910 40.50%


Thank you in advance

=sumproduct(--(a1:a100=z1),--(B1:B100=z2),(c1:c100))
where column A are your ticker symbols
column B are the Box numbers
column C are the %
and z1 and z2 are the inputs like Z1= QQQQ and z2 = BOX549

OR

=index(c1:c100,match(z1&z2,a1:a100&B1:B100,0))
array entered (ctrl+shift+enter)


"carl" wrote in message
...
My data looks like so:

SPY BOX549 48.70%
SPY BOX910 40.50%
SPY BOX913 5.10%
SPY BOX060 2.20%
SPY BOX980 1.20%
SPY BOX958 1.10%

QQQQ BOX549 33.00%
QQQQ BOX980 21.50%
QQQQ BOX912 16.60%
QQQQ BOX910 16.40%
QQQQ BOX913 5.80%

I have a another table that looks as so:

QQQQ BOX549
SPY BOX910

I would like to try a formula in c1 that will look at a1 and a2 and then
look at the table 1 and return the value in col c...for example

QQQQ BOX549 33.00%
SPY BOX910 40.50%


Thank you in advance