can any one help me to using lookup function with more then one condition,
B Bob Phillips Apr 12, 2006 #2 =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)
=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)
