Index, Match, If

[Shortstopper00]

I have a data set that is user based. The answer that i want to bring up is
dependant on 3 variables. The first is the month it is (column), second is
the type of day sunny or cloudy (cloumn) and the third is the time of day
which is in a row. If anyone could help me with a code taht could be used it
would be greatly appreciated.
1 2 3
April Sunny 3.7 3.2 2.8
April Cloudy 4.1 3.7 3.2
July Sunny 16.3 15.7 15.2
July Cloudy 18.6 18.2 17.5
October Sunny 6.9 6.1 5.7
October Cloudy 7.2 6.7 6.1

 

[Max]

Assume your reference table as posted is in A1:E7

Assume the triple inputs in G2:I2 are: October, Sunny, 2

In J2, normal ENTER:
=INDEX(C2:E7,MATCH(1,INDEX((A2:A7=G2)*(B2:B7=H2),),0),MATCH(I2,C1:E1,0))
will return the reading 6.1

Changing the triple inputs to: July, Sunny, 3
will yield in J2: 15.2

Adapt the ranges to suit
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:363 Subscribers:64
xdemechanik

 

[T. Valko]

see other post