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?

Who is Participating?
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
a) yes
b) I assume cell of Jan(123) is D4(D5)
your formula will read like this:

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

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.