Index Match / lookup formula using column names

[MrSamExcel]

Is there a way I can modify this Index Match formula, or use a different formula, so that I can reference by column/field names instead of clicking on specific column references?:
=INDEX(source!E:E,MATCH(A2,source!D:D,0))
Instead of source!E:E I'd like to find "DESCRIPTION" in row1 of the 'source' tab; instead of source!D:D I'd like to find "FUNDCODE" in row1 of 'source' tab.

Excel 2013 64 bit
[TABLE="class: head"]
<tbody>[TR="bgcolor: #888888"]
[TH][/TH]
[TH]

A​

[/TH]
[TH]

B​

[/TH]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

1​

[/TD]
[TD]FUND_CODE[/TD]
[TD]FUND_NAME[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

2​

[/TD]
[TD]AA[/TD]
[TD]=INDEX(source!E:E,MATCH(A2,source!D:D,0))[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

3​

[/TD]
[TD]GA[/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

4​

[/TD]
[TD]CO[/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

5​

[/TD]
[TD]CT[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid"]
<tbody>[TR]
[TD]Sheet: formula[/TD]
[/TR]
</tbody>[/TABLE]


[TABLE="class: head"]
<tbody>[TR="bgcolor: #888888"]
[TH][/TH]
[TH]

A​

[/TH]
[TH]

B​

[/TH]
[TH]

C​

[/TH]
[TH]

D​

[/TH]
[TH]

E​

[/TH]
[TH]

F​

[/TH]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

1​

[/TD]
[TD]FEEDNAME[/TD]
[TD]FEEDID[/TD]
[TD]FEEDDATE[/TD]
[TD]FUNDCODE[/TD]
[TD]DESCRIPTION[/TD]
[TD]CLASS[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

2​

[/TD]
[TD]Mutual Funds Setup[/TD]
[TD]MFDP0802[/TD]
[TD]12/31/2016[/TD]
[TD]AA[/TD]
[TD]American[/TD]
[TD]A[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

3​

[/TD]
[TD]Mutual Funds Setup[/TD]
[TD]MFDP0802[/TD]
[TD]12/31/2016[/TD]
[TD]CO[/TD]
[TD]Colorado[/TD]
[TD]C2[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

4​

[/TD]
[TD]Mutual Funds Setup[/TD]
[TD]MFDP0802[/TD]
[TD]12/31/2016[/TD]
[TD]CT[/TD]
[TD]Connecticut[/TD]
[TD]I[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

5​

[/TD]
[TD]Mutual Funds Setup[/TD]
[TD]MFDP0802[/TD]
[TD]12/31/2016[/TD]
[TD]GA[/TD]
[TD]Georgia[/TD]
[TD]C[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid"]
<tbody>[TR]
[TD]Sheet: source[/TD]
[/TR]
</tbody>[/TABLE]

Thanks.

 

[steve the fish]

This should work:

=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))

 

[MrSamExcel]

Works perfectly, thanks for your help and quick response!

 

[MrSamExcel]

Four and half years later and I'm still using this solution, thanks! I think the question below is an extension of the original question, but if moderator disagrees I will start new thread.
Is there a way I could expand this approach to account for 2 criteria? In the orig example above, the formula returns DESCRIPTION if it finds a match for A2 in the FUNDCODE field of 'source' tab. Is there a non-array formula 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 just like the original post.

 

[Fluff]

You would be far better off starting a new thread, especially as it's a different question.

 

[MrSamExcel]

Will do, thanks.

 

[MrSamExcel]

Will do, thanks.

In case anyone else is looking for similar expansion: Index Match / lookup using column names and