lookup H&V...or match...index???
Try this€¦
=SUMPRODUCT((C1:G1="ORANGE")*(B2:B4=200)*(C2:G4))
Or
Put this formula in I2 cell
=SUMPRODUCT((C1:G1=I1)*(B2:B4=J1)*(C2:G4))
In I1 cell type €śOrange€ť and J1 cell type €ś200€ť.
--
Remember to Click Yes, if this post helps!
--------------------
(Ms-Exl-Learner)
--------------------
"Kevin W" wrote:
Hi,
I probably have 30 or so columns and 200 rows. For simplicity if I have:
A B C D E F
1 Blue Green Red Orange Purple
2 100 2 4 6 3 5
3 200 8 9 5 7 2
4 300 5 8 1 3 2
The names of the columns are colors and the names of the rows are numbers
(and they are all known beforehand).
What formula do I need to retrieve the value of the cell that corresponds to
Orange and 200 (so I want to retrieve the number 7)?
Thanks!
|