=INDEX(C2:C20,MATCH(1,(A2:A20="x")*(B2:B20="y"),0) )

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"zia" wrote in message
...
can any one help me to using lookup function with more then one condition,