Referring to specific cell in named range in Excel formula

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,
 
L

Luke M

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

=INDEX(filename!rangename,2)
 
N

Nigel Barton

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...
 
O

OutsideObserver

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I have a cell value define a dynamic named range? 15
Constructing Range Name calls with Concatenate 4
Refer to a named range indirectly 2
Use Text and Cell vale to reference a named range inside a formula 1
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
a data validation list that contains a list of named ranges - not alist from a named range 1
CF Warning Formula 1
Excel JUMP FROM SEARCH BAR TO RESULT 3

Top