Hi Mike try this.

Assuming you have a look up table like this on sheet 2

col A ----- colB ----- col C
---5----------1---------0.1 e.g
---5----------8---------0.2
---5----------6---------0.3
---5---------14--------0.4
--15---------1---------0.5
--15---------8---------0.6
--15---------6---------0.7
--15--------14--------0.8

If you have your validated list in row 2 with 5 or 15
and you have a validated list in row 3 with 1, 8, 6, 14

In B4 put the following

=INDEX(IF(B$2=Sheet2!$A$1:$A$8,Sheet2!$C$1:$C$8),M ATCH(B$3,IF(B$2=Sheet2!$A$1:$A$8,Sheet2!$B$1:$B$8, 0)))


you need to enter the formula using control + shift + enter.

HTH.


--
greg7468


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