ExcelBanter - lookup with more then one codition

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - lookup with more then one codition (https://www.excelbanter.com/excel-worksheet-functions/82937-lookup-more-then-one-codition.html)

zia

lookup with more then one codition

can any one help me to using lookup function with more then one condition,

Bob Phillips

lookup with more then one codition

=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,

All times are GMT +1. The time now is 11:41 PM.