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

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Go to cell referenced in a formula	Dennis	Excel Discussion (Misc queries)	7	May 7th 23 07:41 PM
bold text of referenced cell show in formula cell	zabcikranch	Excel Worksheet Functions	1	February 2nd 10 07:42 PM
why does formula not work until I clear referenced cell ??	colwyn	Excel Discussion (Misc queries)	3	October 20th 08 10:22 PM
How can i jump to a cell referenced in a formula?	PowerExcelWannabe	Excel Discussion (Misc queries)	1	September 30th 05 07:38 PM
function CELL() to return the formula in the referenced cell	Streep	Excel Worksheet Functions	3	August 20th 05 10:24 PM

All times are GMT +1. The time now is 06:23 AM.

Menu

About Us