Referring to specific cell in named range in Excel formula

  • Thread starter Thread starter Nigel Barton
  • Start date Start date
N

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,
 
Perhaps you can use some form of INDEX? Assuming your range is a single column:

=INDEX(filename!rangename,2)
 
Perfect!

--
Nigel Barton


Luke M said:
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!*
Click to expand...
 
Perhaps you can use some form of INDEX? Assuming your range is a single column:

=INDEX(filename!rangename,2)
Click to expand...


I use vlookup and named ranges.

A single column though...talk to Luke.
 
Back
Top