Dropdown list selections

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

Hello Wisconsin
(sorry I love the 70s show)

Formula:

M12: =INDEX($J$3:$L$269,MATCH($M$8,CITIES,0),MATCH($M$10,CONTROL,0))
format cell to percentage

I've changed you name:Control refers to ='percent sunny cloudy'!$J$2:$L$2

Now M12 becomes:

Please Login or Register  to view this content.

rwg, no need to change the contents of the named range in this instance (given this after all UI preference) - given the two lists correlate in terms of order you can just match selection against the named range itself (as shown).

D.O