Try the following array formula, entered using CONTROL+SHIFT+ENTER...

=INDEX(RangeC,MATCH(1,(RangeA="First Lookup Value")*(RangeB="Second
Lookup Value"),0))

Note that if your lookup value is numerical, remove the quotes.

Hope this helps!


--
Domenic
------------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785
View this thread: http://www.excelforum.com/showthread...hreadid=274073