|I'm not if this is what you are looking, so let me know...|
In 2004 Portfolio!B2 you have a value of 6013.42 which I assume came from MV 2004-2005!KF2.
This formula will return that value from MV 2004-2005 using the INDEX and MATCH functions.
The first thing I did was turn MV 2004-2005 into a Named Range (MyData). I then used the following formula to return 6013.42 into 2004 Portfolio!B2
The MATCH functions will return the row_num of the value in 2004 Portfolio!A2 and column_num of the value in 2004 Portfolio!B1 based on where they are found in MyData (MV 2004-2005).
It will then use those row_num and column_num values in the INDEX function to return the value found at that intersection.
=INDEX(MyData,MATCH(A2,'MV 2004-2005'!A:A,0),MATCH(B1,'MV 2004-2005'!1:1,0))
Hope that helps!
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.