View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default match, Index, If

Ah, darned, you multi-posted in .misc. Pl refrain from doing this
Below's my response to you over the
----- ----
Assume your reference table as posted is in A1:E7

Assume the triple inputs in G2:I2 a 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
---