Index Match / lookup using column names and

MrSamExcel

Board Regular
Joined
Apr 6, 2016
Messages
51
Office Version
  1. 365
  2. 2021
Platform
  1. Windows
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
3Mutual Funds SetupMFDP080212/31/2016COColoradoC2
4Mutual Funds SetupMFDP080212/31/2016CTConnecticutI
5Mutual Funds SetupMFDP080212/31/2016GAGeorgiaC
Sheet: source
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
Bump, no replies. Let me know if I need to provide clarification or violated any forum rules.
 
Upvote 0

Forum statistics

Threads
1,223,883
Messages
6,175,168
Members
452,615
Latest member
bogeys2birdies

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top