Match, Index, If
Shortstopper00 wrote:
I'm making a user based questionaire. I need them to input 4 different
variables and based on those variables I need a single number to be picked
out of an index. I'm not exactly sure how the code would look. Here is an
example of what I am trying to do. The city, sunny or cloudy, month and time
(1,2,3) are the variables.
1 2 3
Toronto Sunny Jan 4.5 5.7 6.7
Toronto Cloudy Jan 34 3 12
Ottawa Sunny Jan 23.5 45 14
Ottawa Cloudy Jan 32 4.8 54
One way...
I arranged your sample table in A1:F5 and the criteria (#; City; Sunny
etc; Month) in H1:H4. This is an array formula (commit with
Ctrl+Shift+Enter, not just Enter):
=INDEX(D2:F5,MATCH(1,(H2=A2:A5)*(H3=B2:B5)*(H4=C2: C5),0),MATCH(H1,D1:F1,0))
|