View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default 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