Indexing using 3 qualifiers

J

jonnyboy

New member
Joined
Jun 26, 2014
Messages
2
Reaction score
0
Points
0
Using indexing, how do I populate J2 to J13 with values from column E based on inputs in columns G, H and I

26-06-2014 19-10-16 2.png
 
Fixed

{=INDEX($E:$E,MATCH(1,IF($A:$A=$G3,IF($B:$B=$H3,IF($C:$C<=$I3,IF($D:$D>=$I3,1))),0),0))}
 
You must log in or register to reply here.
Back
Top