Excel indirect help

Soldato
Joined
18 Oct 2002
Posts
7,515
Location
Maidenhead
Hi,

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
 
Back
Top Bottom