Absolute address for Indirect function

[Hari]

Hi,

I want to make the reference in indirect function absolute because Im
copying this function to lots of successive row.

For ex. in F3 I have the formula --> =IF(ISERROR(VLOOKUP($D3,INDIRECT("'Raw
Data'!$B$3:$K$"&T1),10,FALSE)),"",VLOOKUP($D3,INDIRECT("'Raw
Data'!$B$3:$K$"&T1),10,FALSE))

Now I need to copy this formula to F4 , F5 and depending on the data range
(which would change from one time to another) I will need to paste it down
to
F5000.

My only problem is when I paste it down using autofill then the part -->
INDIRECT("'Raw Data'!$B$3:$K$"&T1) changes to INDIRECT("'Raw
Data'!$B$3:$K$"&T2) and so on that is the reference T1 keeps on updating
itself . How do I ensure that the reference is always to T1 cell only

Please guide me.

Regards,
Hari
India

 

[Hari]

Hi,

I got it.

I thought that writing it as INDIRECT("'Raw Data'!$B$3:$K$"&$T$1) might not
work as we have an ampersand before dollar sign. But I shud have atleast
tried before posting it.

Regards,
Hari
India