Darrin Smith
New Member
- Joined
- Sep 29, 2006
- Messages
- 12
I am wanting to use text inputs to alter numbers in a formula.
i.e. the numerical value of cell E11 is utilised in a formula. This numerical value is required to change depending on the text entered in cell E10.
i.e.
if HJV entered in E10, E11 should be 669.
if YSL entered in E10, E11 should be 656.
if TOE entered in E10, E11 should be 640.
etc, etc
How to do this?
Rgds
Darrin
i.e. the numerical value of cell E11 is utilised in a formula. This numerical value is required to change depending on the text entered in cell E10.
i.e.
if HJV entered in E10, E11 should be 669.
if YSL entered in E10, E11 should be 656.
if TOE entered in E10, E11 should be 640.
etc, etc
How to do this?
Rgds
Darrin