macro to unhide row when a dropdown list item is selected

Hi,

I have this spreadsheet (attached). Originally, the spreadsheet only had the states that were highlighted in blue. I wanted a macro such that a user could chose what state to add from a dropdown list. I was thinking of putting the remaining states on the sheet (those that weren't highlighted in blue) and whenever the user select a state, that row will be unhide. But it would be a lot of If statements if I do it that way, so I'm hoping if anyone have any other ideas or know how to do this without putting tons of If statements.

There are more columns to the right of the Total column that have formulas in them to calculate % and such when the user input numbers in the 2nd - 4th columns

Any help would be greatly appreciated!

Thanks!