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

Kerry
Guest
Posts: n/a

 15th Mar 2010
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

Bernard Liengme
Guest
Posts: n/a

 15th Mar 2010
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

Kerry
Guest
Posts: n/a

 16th Mar 2010
On Mar 15, 5:09*pm, "Bernard Liengme" <(E-Mail Removed)>
wrote:
> Try:
> =IF(ROW(A3)<AO\$1,INDIRECT("Page2!\$A"&B1),"")
> best wishes
> --
> Bernard Liengme
> Microsoft Excel MVPhttp://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

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

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post Ryan H Microsoft Excel Programming 4 18th Mar 2010 08:15 PM Carsten Marx Microsoft C# .NET 0 20th Dec 2007 02:38 PM Daiya Mitchell Microsoft Word Document Management 0 16th Sep 2005 12:39 AM Suzanne S. Barnhill Microsoft Word Document Management 0 15th Sep 2005 06:32 PM Lenny Microsoft Frontpage 5 7th Dec 2003 10:45 PM

Features

Newsgroups

All times are GMT +1. The time now is 10:53 PM.