Hi mon amie,
Pierre Leclerc Wrote:
You cannot really use INDEX/MATCH with 2 criterias,...
Yes you can. I'd suggest you give my example a try. :)
...use SUMPRODUCT as
explained in a previous message.
SUMPRODUCT is fine if, as in this case, the value to return is a
numerical one. But in other cases, if the value to be returned is a
text value, you would need INDEX/MATCH. And you can either use the
array formula I offered or, if an array formula doesn't appeal to you,
go the round about route using concatenation.
--
Domenic
------------------------------------------------------------------------
Domenic's Profile:
http://www.excelforum.com/member.php...o&userid=10785
View this thread:
http://www.excelforum.com/showthread...hreadid=319143