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+$...
I click on cell B1 goto the box and type Lunch then ENTER but when I click back on cell B! the box shows B1 not Lunch
It seems your named range "Lunch" is problematic. Maybe define a new name like "Lunch_price" which most likely will work as described.
Then Find and Replace Lunch with Lunch_price in formulas.
Then Find and Replace Lunch with Lunch_price in formulas.
Sorry but "Lunch_price" does not work either. Guess I will have to stick with $B$1