Index & Match error

**vb613** · 04-23-2007, 02:12 AM

I wonder if there is a way to have the index & match in lookup multi criteria to return blank if the criteria does not match. as the example below.

{=INDEX($A$2:$A$7,MATCH(1,(A10=$B$2:$B$7)*(B10=$C$2:$C$7),0))}

Thanks,

**starguy** · 04-23-2007, 02:31 AM

Originally Posted by vb613

I wonder if there is a way to have the index & match in lookup multi criteria to return blank if the criteria does not match. as the example below.

{=INDEX($A$2:$A$7,MATCH(1,(A10=$B$2:$B$7)*(B10=$C$2:$C$7),0))}

Thanks,

SUMPRODUCT formula may help you instead.
see link below.

http://www.xldynamic.com/source/xld.SUMPRODUCT.html