How to Specify a range using another cell vale instead of row number

Hi Everybody,

Normally when we specify range in excel we specify as
$A$1:$A$1000, But I for my specific problem I need to specify range
using a vlue of a cell. i.e. $A$1:$A$B1, Where B1 can have a value
between 2to 1000, Is it possible, If so Pl. tell me in what method I
can do That.

Thanks and Regards

Ramana

$A$1:INDEX(A:A,$B$1)

ramana wrote:
> Hi Everybody,
>
> Normally when we specify range in excel we specify as
> $A$1:$A$1000, But I for my specific problem I need to specify range
> using a vlue of a cell. i.e. $A$1:$A$B1, Where B1 can have a value
> between 2to 1000, Is it possible, If so Pl. tell me in what method I
> can do That.
>
> Thanks and Regards
>
> Ramana
>