Thread: Help with multiple match and index formula
View Single Post
 
Old 09-12-2012, 07:53 AM
Portucale Portucale is offline Windows 7 32bit Office 2010 32bit
Novice
  
Join Date: Sep 2012
Posts: 3
Portucale is on a distinguished road
Default Help with multiple match and index formula
Try this one...

=INDEX($E$2:$E$7,MATCH(1,INDEX(("Adult"=$B$2:$B$7) *("Art"=$D$2:$D$7),0,0),0))

Enclosed is also another one using an Array formula...

Cheers
Attached Files
File Type: xls Double Index.xls (26.5 KB, 16 views)
Reply With Quote