Three Way Lookup: INDEX and MATCH with blank space in row header

[litan]

I'm trying to do a three way lookup when there are two row header variables and two column header variable using INDEX and MATCH.

I want to fill the table with dollar amount by match Id code, name and month. There is blank space from month to month. I tired this below formula but obviously this doesn't work.
=INDEX(A14:L14,MATCH(A2:A4&B2:B4,B8&C8,),MATCH(C1,A12:L12))

Is this doable? please help.

Id Code	Name	Jan	Feb	Mar	Apr	May	Jun
100001	Tom	#VALUE!
100064	John
100066	Joe
Id Code	100001	Tom
	100064	John
	100066	Joe
	Jan		Feb		Mar		Apr		May		Jun
Hours	Dollars	Hours	Dollars	Hours	Dollars	Hours	Dollars	Hours	Dollars	Hours	Dollars
-	$ 10.00	-	$ 20.00	-	$ 40.00	-	$ 60.00	-	$ 80.00	-	$ 100.00

<tbody>
</tbody>

 

[cyrilbrd]

Hi, please clarify.
What would be the expected result?
<style>table { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: black; font-size: 12pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri,sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl64 { vertical-align: middle; white-space: normal; }.xl65 { text-align: right; vertical-align: middle; white-space: normal; }.xl66 { text-align: center; vertical-align: middle; white-space: normal; }</style>

Id Code	Name	Jan	Feb	Mar	Apr	May	Jun
100001	Tom	10	20	40	60	80	100
100064	John	10	20	40	60	80	100
100066	Joe	10	20	40	60	80	100

<tbody>
</tbody>