Thread: Referring to specific cell in named range in Excel formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nigel Barton Nigel Barton is offline
external usenet poster
  
Posts: 8
Default 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
Reply With QuoteReply With Quote