Posted to microsoft.public.excel.worksheet.functions

Chris

external usenet poster

Posts: 71

How to expand Index/Match formula

I have the following formula below, but I want the formula to also
match columnD in addition to columnA on my Data! sheet. ColumnA and
ColumnD on Data! needs to match ColumnC and ColumnE respectively
before returning columnE from Data! on my other sheet.

=INDEX(Data!E:E,MATCH(C2,Data!A:A,0))

Any ideas?

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
help with Index and Match Formula	klafert	Excel Worksheet Functions	1	May 9th 07 11:28 AM
Formula INDEX/MATCH	MadMax	Excel Worksheet Functions	1	February 2nd 07 04:48 PM
Index / Match in formula	MRR	Excel Worksheet Functions	2	January 10th 07 05:52 PM
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 formula	andrewm	Excel Worksheet Functions	3	July 22nd 05 08:36 AM

All times are GMT +1. The time now is 05:02 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us