Forum Discussion
Reference a single named cell
I want reference a single named cell in a formula e.g.
In cell A1:-
=D1+Lunch this gives me an err #NAME?
In Cell b1 is 34.5 This cell is named as 'Lunch'
This works:-
=D1+$B$1
.
.
.
=D23+$B$1
How can I refer to Lunch instead of $B$1
Any advice please?
10 Replies
- I am using Excel online . I do not see the menu bar you show. Where do I find "Formulas?
In Excel for web there is no Name Manager. You may define the name using Name Box under the grid on the left
After that staying on the cell you shall see the name, not address in the Name Box.
final formula works
