Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 299
  • Last Modified:

Excel - CallbyName type functionality in named ranges?

Hi - this may be a little complicated to explain, but I'll give it a go.

1) Say I have a named range of one cell called "MyRange" which will contain the number of the month of the year.

2) I also have a row Jan, Feb, Mar, Apr etc, denoting the months of the year, and under each month is some sort of monetary value for that month. E.g.
Jan    Feb    Mar    
123    456    789

3) Now, I want another cell to reference the amount for the month number in the named range "MyRange". Its cecll formula may be something like - "=MyRange:3". This obviously doesn't work, but may be similar to call by name in VB6. Does anyone a) understand what I'm going on about and b) know if you can do this easily?

Ta.
0
NikWhitfield
Asked:
NikWhitfield
  • 2
  • 2
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
a) yes
b) I assume cell of Jan(123) is D4(D5)
your formula will read like this:
=OFFSET(C5;0;MyRange)

Hope this helps
0
 
NikWhitfieldAuthor Commented:
This is giving me a syntax error and highlighting the C5 part of the function. Any ideas?
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
you may have , as List Separator instead of ;
0
 
NikWhitfieldAuthor Commented:
I got it - commas instead of semicolons!  Cheers.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now