Thread: VLOOKUP help
View Single Post
  #7   Report Post  
Domenic
 
Posts: n/a
Default


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