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
 
	 
 ![A[L]C](/styles/overclockers/avatars/7.png)