Mike, do have lookup table on sheet 2 with the following

- col A --- col B --- col C --- col D --- col E --- col F
--------------5-------------------8--------------------1
--------------5------------------10--------------------2
--------------5------------------12--------------------3
--------------5------------------500------------------4
--------------15------------------8--------------------5
--------------15-----------------10-------------------6
--------------15-----------------12--------------------7
--------------15----------------500-------------------8
--------------25------------------8--------------------9
--------------25-----------------10--------------------10
--------------25-----------------12--------------------11
--------------25-----------------500-------------------12


and row 2 sheet 1 it is validated to values of 5, 15, and 25
and row 3 sheet 1 it is validated to values of 8, 10, 12 and 500

and you have array entered (control +shift + enter) this formula into
B4 on sheet 1

=INDEX(IF(B$2=Sheet2!$B$1:$B$12,Sheet2!$F$1:$F$12) ,MATCH(B$3,IF(B$2=Sheet2!$B$1:$B$12,Sheet2!$D$1:$D $12,
0)))

HTH


--
greg7468


------------------------------------------------------------------------
greg7468's Profile: http://www.excelforum.com/member.php...fo&userid=9031
View this thread: http://www.excelforum.com/showthread...hreadid=379296