# Index Match / lookup using column names and

#### MrSamExcel

##### New Member
Is there a non-array Index Match formula that references field names instead of specific columns and allows for multiple search criteria? Here is my original post that solves the "reference field names" function:
Index Match / lookup formula using column names
Can I expand on this approach to account for 2 criteria? In the orig example, the formula returns DESCRIPTION from 'source' tab if it finds a match for A2 from 'formula' in the FUNDCODE field of 'source'. What about a formula in B2 that returns DESCRIPTION if FUNDCODE = A2 and FEEDID <> A2? I found a non-array INDEX/MATCH with multiple criteria formula using specified columns, but could not adapt it to reference field names like the original post. Thanks.

Excel 2013 64 bit

AB
1FUND_CODEFUND_NAME
2AA=INDEX(source!\$A\$1:\$F\$5,MATCH(A2,INDEX(source!\$A\$1:\$F\$5,,MATCH("FUNDCODE",source!\$A\$1:\$F\$1,0)),0),MATCH("DESCRIPTION",source!\$A\$1:\$F\$1,0))
3GA
4CO
5CT
 Sheet: formula

ABCDEF
1FEEDNAMEFEEDIDFEEDDATEFUNDCODEDESCRIPTIONCLASS
2Mutual Funds SetupMFDP080212/31/2016AAAmericanA
4Mutual Funds SetupMFDP080212/31/2016CTConnecticutI
5Mutual Funds SetupMFDP080212/31/2016GAGeorgiaC
 Sheet: source

### Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a \$25,000 loan, 5% annual interest, 60 month loan.

#### MrSamExcel

##### New Member
Bump, no replies. Let me know if I need to provide clarification or violated any forum rules.

Replies
3
Views
129
Replies
1
Views
320
Replies
6
Views
241
Replies
1
Views
67
Replies
4
Views
373

1,195,640
Messages
6,010,868
Members
441,571
Latest member
stolenweasel

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back