Apologies. Think I forgot to fix the reference to col D earlier
The corrected formulas should read:
In Q2:
=IF($D2="Mil.",INDEX($B:$B,MATCH(TRIM(E2),$A:$A,0) ),INDEX($B:$B,MATCH(TRIM(K2),$A:$A,0)))
Copy Q2 to U2
In W2:
=IF($D2="Mil.",INDEX($E2:$I2,MATCH(SMALL($Q2:$U2,C OLUMN(A:A)),$Q2:$U2,0)),INDEX($K2:$O2,MATCH(SMALL( $Q2:$U2,COLUMN(A:A)),$Q2:$U2,0)))
Copy W2 to AA2
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---