You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"bim-bom" wrote in message
...
T. Valko pisze:
One way...

Array entered** :

=INDEX(C1:C3,MATCH(1,IF(A1:A3=5,IF(B1:B3=6,1)),0))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the
SHIFT key then hit ENTER.


Thank you very much - it works perfectly. Now I know how to know make
things like that.