creating a formula that looks at the value of another cell and usesthat value as the row value for for a referenced cell

's Computer Specifications

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

's Computer Specifications

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:816390fc-f00a-48a7-aceb-(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

's Computer Specifications

On Mar 15, 5:09*pm, "Bernard Liengme" <blien...@TRUENORTH.stfx.ca>
wrote:
> Try:
> =IF(ROW(A3)<AO$1,INDIRECT("Page2!$A"&B1),"")
> best wishes
> --
> Bernard Liengme
> Microsoft Excel MVPhttp://people.stfx.ca/bliengme
>
> "Kerry" <kbro...@gmail.com> wrote in message
>
> news:816390fc-f00a-48a7-aceb-(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

Thanks, that works perfectly. I think adding INDIRECT to my excel
lexicon will be useful in the future too.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
bold text of referenced cell show in formula cell	zabcikranch	Microsoft Excel Worksheet Functions	1	2nd Feb 2010 07:42 PM
Cell reference - displays formula rather then referenced cell	=?Utf-8?B?TWlrZUE=?=	Microsoft Excel Crashes	2	6th Aug 2007 01:32 PM
Go to cell referenced in a formula	=?Utf-8?B?RGVubmlz?=	Microsoft Excel Misc	6	30th May 2006 09:29 PM
function CELL() to return the formula in the referenced cell	=?Utf-8?B?U3RyZWVw?=	Microsoft Excel Worksheet Functions	3	20th Aug 2005 10:24 PM
contents of cell referenced into formula	Dave the Man	Microsoft Excel Worksheet Functions	1	29th Feb 2004 06:51 PM