PC Review


Reply
Thread Tools Rate Thread

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
 
Reply With Quote
 
 
 
 
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


 
Reply With Quote
 
 
 
 
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.
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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 Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Close Referenced Workbook if it's No Longer Referenced Ryan H Microsoft Excel Programming 4 18th Mar 2010 08:15 PM
Label.Text -> In VS2005-Designer it looks fine -> In runningapplication it looks ugly Carsten Marx Microsoft C# .NET 0 20th Dec 2007 02:38 PM
Re: Duplicate cross-referenced footnotes on cross-referenced page Daiya Mitchell Microsoft Word Document Management 0 16th Sep 2005 12:39 AM
Re: Duplicate cross-referenced footnotes on cross-referenced page Suzanne S. Barnhill Microsoft Word Document Management 0 15th Sep 2005 06:32 PM
Some unfixable differences between what the page looks like in Frontpage and what it looks like in the browser Lenny Microsoft Frontpage 5 7th Dec 2003 10:45 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:36 AM.