How to expand Index/Match formula

C

Chris

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?
 
T

T. Valko

If I understand correctly:

Array entered** :

=INDEX(Data!E1:E100,MATCH(1,(Data!A1:A100=C2)*(Data!D1:D100=C2),0))

Since this is an array formula** you can't use entire columns as range
references unless you're using Excel 2007.

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top