Results 1 to 2 of 2

Thread: Indexing using 3 qualifiers

  1. #1

    Indexing using 3 qualifiers



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Using indexing, how do I populate J2 to J13 with values from column E based on inputs in columns G, H and I

    Click image for larger version. 

Name:	26-06-2014 19-10-16 2.png 
Views:	14 
Size:	56.0 KB 
ID:	2451

  2. #2
    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))}

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •