lookup H&V...or match...index???
Hi,
try
=INDEX(B3:F5,MATCH(I1,A3:A5,0),MATCH(I2,B2:F2,0))
index(B3:F5 is where the information to be retrieved is
match(I1, A3:A5 = I1 is where I enter 200 and A3:A5 the range where the
values are
match(I2,B2:F2 = I2 is where I typed orange and B2:F2 is the range where
your colors are
change ranges and cells to fit your needs
"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!
|