Solved: Combine H and V lookup or better idea?

[grichey]

I have the following workbook example. I'm trying to link the yellow cells on 'Linked' to the corresponding cells on 'Hardcoded'. There's no gaurantee that the descriptions in A:A or in 1:1 will be in the same order so doing a simple vlookup wont work because columnindex can change.

I'm trying to figure out how to link it where it would look the formula would look for the equivalent cell in the hardcoded sheet that has the same Column and Row header.

Thanks.

[Bob Phillips]

=INDEX(HardCode!$A$1:$E$5,MATCH(Linked!F$1,HardCode!$1:$1,0),MATCH(Linked!$ A2,HardCode!$A:$A,0))

[grichey]

=INDEX(HardCode!$A$1:$E$5,MATCH(Linked!$A2,HardCode!$A:$A,0),MATCH(Linked!F $1,HardCode!$1:$1,0))

Thanks. It was nearly right! I didn't know a/b index.