IF, INDEX and MATCH - ExcelBanter

Posted to microsoft.public.excel.worksheet.functions

LJ[_2_]

external usenet poster

Posts: 7

IF, INDEX and MATCH

I was using the formula below to match 2 indicators listed within an
array. I have another 2 indicators that I CANNOT add to the array.
They lie in cells AA2 and AB2. How can I modify the formula below to
Index all 4 indicators.

=INDEX($A$1:$E$42, MATCH(Y2,$A$1:$A$42,0),MATCH(Z2,$A$1:$E$1,0))

Thanks for the help in advance.

LJ

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Find Exact Match using INDEX, MATCH	DoubleUU	Excel Worksheet Functions	3	August 15th 08 02:42 PM
index(match) Wind Uplift Calculations (match four conditions)	JMeier	Excel Worksheet Functions	8	August 1st 08 01:45 AM
index match array function-returning only first match, need last.	Julie Olsen	Excel Worksheet Functions	3	December 29th 06 12:50 AM
How do I display more than one match in a Index/Match formula?	Trish	Excel Worksheet Functions	0	September 26th 05 10:21 PM
index,match,match on un-sorted data	Brisbane Rob	Excel Worksheet Functions	3	September 24th 05 10:04 PM

All times are GMT +1. The time now is 04:55 PM.

Menu

About Us