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

	A​	B​
1​	FUND_CODE	FUND_NAME
2​	AA	=INDEX(source!E:E,MATCH(A2,source!D:D,0))
3​	GA
4​	CO
5​	CT

<tbody>
</tbody>

Sheet: formula

<tbody>
</tbody>

	A​	B​	C​	D​	E​	F​
1​	FEEDNAME	FEEDID	FEEDDATE	FUNDCODE	DESCRIPTION	CLASS
2​	Mutual Funds Setup	MFDP0802	12/31/2016	AA	American	A
3​	Mutual Funds Setup	MFDP0802	12/31/2016	CO	Colorado	C2
4​	Mutual Funds Setup	MFDP0802	12/31/2016	CT	Connecticut	I
5​	Mutual Funds Setup	MFDP0802	12/31/2016	GA	Georgia	C

<tbody>
</tbody>

Sheet: source

<tbody>
</tbody>

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