JenniferMurphy
Well-known Member
- Joined
- Jul 23, 2011
- Messages
- 2,535
- Office Version
- 365
- Platform
- Windows
I have been using the @ notation a lot since it was suggested to me here. It has made a lot of things easier.
I just encountered a situation where it does not appear to. Can anyone help me understand what is going on?.
In this table, I assigned the name "Values" to the range D8:D12, the literal values). When I tried access that range using the @ notation (@Values), which I thought would resolve to the value ij the cell in that range that is on the same row. It works in some situations, but not in others.
In Column E, I use @Values to get the member of the named range that is on the same row. The formulas are shown in Column H. It works perfectly.
Columns F & G should return the same values, but they don't. In F, I use @Values, which fails. In G, I use a cell reference. It works.
What is going on? What am I doing wrong?
I just encountered a situation where it does not appear to. Can anyone help me understand what is going on?.
In this table, I assigned the name "Values" to the range D8:D12, the literal values). When I tried access that range using the @ notation (@Values), which I thought would resolve to the value ij the cell in that range that is on the same row. It works in some situations, but not in others.
In Column E, I use @Values to get the member of the named range that is on the same row. The formulas are shown in Column H. It works perfectly.
Columns F & G should return the same values, but they don't. In F, I use @Values, which fails. In G, I use a cell reference. It works.
What is going on? What am I doing wrong?