westend9876
Member
Here is my current working formula
=INDEX(AUDUSD!AF31:AUDUSD!AM31,0,MATCH(E6,AUDUSD!AF1:AUDUSD!AM1,0))
However, I need to reproduce a formula that will produce the same result with the cell references broken apart in other cells as follows:
A8 - AUDUSD
B8 - 1
C8 - 31
D8 - AF
E8 - AM
F8 - The final formula to produce the result.
=INDEX(AUDUSD!AF31:AUDUSD!AM31,0,MATCH(E6,AUDUSD!AF1:AUDUSD!AM1,0))
However, I need to reproduce a formula that will produce the same result with the cell references broken apart in other cells as follows:
A8 - AUDUSD
B8 - 1
C8 - 31
D8 - AF
E8 - AM
F8 - The final formula to produce the result.