Referring to specific cell in named range in Excel formula

[Nigel Barton]

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,

 

[Luke M]

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

=INDEX(filename!rangename,2)

 

[Nigel Barton]

Perfect!

--
Nigel Barton

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!*

 

[OutsideObserver]

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.