# Equation Referencing Row Number Stored in Cell

1. ## Equation Referencing Row Number Stored in Cell

I have an array formula such as ...
={ ... *(\$G\$98:\$AZ\$98)}

The formula references data found in row 98 of the worksheet.

Instead of typing the row number into the formula, I'd like to be able to
refer to a row number that I enter in another cell. For example, if I type
the number 74 into cell A1, I'd like the array formula to reference the value
shown in cell A1 such that the array formula is the equivalent of ...

={ ... *(\$G\$74:\$AZ\$74)}

I use the array formula to create a multi-dimensional data table that I use
for charting. The same formula may be used hundreds of times when creating
the table. I'd like to be able to pull in data stored in any row that I
choose to plot.

I hope I am presenting my case clearly,

Thanks for any help provided.

Jim

2. ## Re: Equation Referencing Row Number Stored in Cell

You can use the INDIRECT function. E.g.,

INDIRECT("G"&A1&":ZA"&A1)

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Jim Hagan" <JimHagan@discussions.microsoft.com> wrote in message
news:FE5C08FE-4827-4C6A-A25F-4C824B8AEB65@microsoft.com...
>I have an array formula such as ...
> ={ ... *(\$G\$98:\$AZ\$98)}
>
> The formula references data found in row 98 of the worksheet.
>
> Instead of typing the row number into the formula, I'd like to
> be able to
> refer to a row number that I enter in another cell. For
> example, if I type
> the number 74 into cell A1, I'd like the array formula to
> reference the value
> shown in cell A1 such that the array formula is the equivalent
> of ...
>
> ={ ... *(\$G\$74:\$AZ\$74)}
>
> I use the array formula to create a multi-dimensional data
> table that I use
> for charting. The same formula may be used hundreds of times
> when creating
> the table. I'd like to be able to pull in data stored in any
> row that I
> choose to plot.
>
> I hope I am presenting my case clearly,
>
> Thanks for any help provided.
>
> Jim

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1