Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Multiple Criteria IF Nesting | Excel Worksheet Functions | |||
Countif using format criteria....not number criteria? | Excel Worksheet Functions | |||
Can I get the mode, min, and max with multiple criteria? | Excel Discussion (Misc queries) | |||
SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
"criteria" in a sumif refering to the value in another cell | Excel Discussion (Misc queries) |