Thread: Lookup problem
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
just_jon
 
Posts: n/a
Default Lookup problem

Guessing at:

Thickness Width Length
Min Max Min Max 0 801 1800
1 19 1 39 50.00% 44.60% 39.90%
1 19 40 93 26.30% 23.10% 20.40%
1 19 94 102 26.00% 22.90% 20.20%
1 19 103 199 25.70% 22.70% 20.00%
1 19 200 210 25.40% 22.40% 19.80%
1 19 211 299 25.20% 22.20% 19.60%
20 39 40 93 17.30% 15.50% 13.40%
20 39 94 102 17.10% 15.30% 13.30%
20 39 103 199 17.00% 15.10% 13.20%

17
109
1800
19.6%

=LOOKUP(2,(1/(A3:A11<=A13)*(B3:B11=A13)*(C3:C11<=A14)*(D3:D11 =A14)),INDEX(E3:G11,0,MATCH(A15,E2:G2)))

Note that the column headers for the last 3 columns must represent the
minimum acceptable value, not the upper limit.