I use this format in one cell E11 to reference another cell E7 and to change
value dased on the name entered in E7 this is the format
=IF(E7="sandy","10", IF(E7="bountiful","11")) I
need to repeat this for 30 different options in the same cell. Is there a
better way? Any other ways? Please help me. Thanks.