Try:

=IF(ROW(A3)<AO$1,INDIRECT("Page2!$A"&B1),"")

best wishes

--

Bernard Liengme

Microsoft Excel MVP

http://people.stfx.ca/bliengme
"Kerry" <(E-Mail Removed)> wrote in message

news:(E-Mail Removed)...

> Seems simple enough, but I have no idea how to do this.

>

> Here's an example:

>

> =IF(ROW(A3)<AO$1,'Page2'!$A?,""), where the question marks denotes the

> row number, the value of which, I want to get from another cell

> altogether. For example,say cell B1 had the value of 1000 and I wanted

> to use that value as my row number in the above formula so something

> like =IF(ROW(A3)<AO$1,'Page2'!$A(value from B1),"") = =IF(ROW(A3)<AO

> $1,'Page2'!$A1000,"")

>

> Thanks,

> K