Hi,
I want to create a formula that contains a named cell that is picked up from another cell.
EG
Cell A1 contains the value 'Complete' this is created by a vlookup, there is a named cell elsewhere called Complete that returns a numerical value (say 5)
I want a formula that is like
=10*A1 which returns the value 50 as 10*A1 = 10*Complete = 10*5 or 50...
How can I get this in to my formula? Any Ideas?
Thanks
Bookmarks