oops forgot to post my formula**
{=INDEX(B30:B35,MATCH(AND(D30:D35=2,E30:E35=1),1)) }


--
chrisrowe_cr
------------------------------------------------------------------------
chrisrowe_cr's Profile: http://www.excelforum.com/member.php...o&userid=25220
View this thread: http://www.excelforum.com/showthread...hreadid=389757