I have 2 dropdown lists. What I would like to happen is after the selections is made in both lists, it refers to the appropriate percentage in another cell and enters it into a 3rd cell. As an example. Someone lives in Birmingham, Al. They choose a lighting scenario of ON/OFF, which corresponds to 42.33%. Or a 2/STEP(52.95%) or 3/STEP(63.56%). I've attached a copy of the spread sheet. Any help would be greatly appreciated. Thank You.
Sincerely, Hustad
Bookmarks