Help with multiple match and index formula

		Microsoft Office Forums > Microsoft Excel > Excel
Help with multiple match and index formula

FAQ

Thread Tools

Display Modes

09-12-2012, 07:53 AM

Portucale

Windows 7 32bit Help with multiple match and index formula

Office 2010 32bit

Novice

Join Date: Sep 2012

Posts: 3

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

Double Index.xls (26.5 KB, 18 views)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula that can merge multiple rows with the same ID into one row	Hilwey	Excel	3	07-08-2015 08:50 PM
Vlookup or Index/Match - Multiple Criteria	ruci1225	Excel	1	01-15-2012 07:31 AM
Word 2010 / Master Index / Multiple Documents	bawrites	Word	0	08-09-2011 11:02 AM
Moving a Index/Match function	FraserKitchell	Excel	2	01-19-2010 09:38 AM
Need another formula to match my last one	tinkertron	Excel	2	04-29-2009 02:17 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:48 AM.