Hi,
I think I need to use indirect, but cannot work out how.
Basically I have this code
This works correctly.
However, I would like to change the sheet name from "1 - 6 CAR HEATS", to whatever value is in cell D1.
Any idea how I do this?
Thanks in advance
I think I need to use indirect, but cannot work out how.
Basically I have this code
Code:
=INDEX('1 - 6 CAR HEATS'!$J$3:$AM$3,MATCH(B5,'1 - 6 CAR HEATS'!$J$5:$AM$5,0))
This works correctly.
However, I would like to change the sheet name from "1 - 6 CAR HEATS", to whatever value is in cell D1.
Any idea how I do this?
Thanks in advance