Referring to specific cell in named range in Excel formula
 

If I have a formula that includes a named range, how can I refer to a
specific cell in that range?

For example

=filename!rangename ...

and I want the value of say the 2nd cell in the range.

Thanks,
--
Nigel Barton

Referring to specific cell in named range in Excel formula
 

Perhaps you can use some form of INDEX? Assuming your range is a single column:

=INDEX(filename!rangename,2)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Nigel Barton" wrote:

If I have a formula that includes a named range, how can I refer to a
specific cell in that range?

For example

=filename!rangename ...

and I want the value of say the 2nd cell in the range.

Thanks,
--
Nigel Barton

Referring to specific cell in named range in Excel formula
 

Perfect!

--
Nigel Barton


"Luke M" wrote:

Perhaps you can use some form of INDEX? Assuming your range is a single column:

=INDEX(filename!rangename,2)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Nigel Barton" wrote:

If I have a formula that includes a named range, how can I refer to a
specific cell in that range?

For example

=filename!rangename ...

and I want the value of say the 2nd cell in the range.

Thanks,
--
Nigel Barton

Referring to specific cell in named range in Excel formula
 

On Tue, 18 Aug 2009 07:33:02 -0700, Luke M
wrote:

Perhaps you can use some form of INDEX? Assuming your range is a single column:

=INDEX(filename!rangename,2)


I use vlookup and named ranges.

A single column though...talk to Luke.