INDEX_MATCH or VLOOKUP with multiple criteria?
Hi,
Am Tue, 29 May 2012 22:03:31 +0200 schrieb Claus Busch:
in C20 try:
=INDEX($K10:$K200,MATCH($B20&"*"&C$18,$I$10:$I$200 &$J$10:$J$200,0))
and drag to E22
it is an array formula to enter with
CTRL+Shift+Enter
sorry, have a typo in it. K10:K200 must also be absolute:
=INDEX($K$10:$K$200,MATCH($B20&"*"&C$18,$I$10:$I$2 00&$J$10:$J$200,0))
Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|