Vlookup for a transposed list or Multiple data validation lists

Hi attached is a worksheet which is part of a much larger workbook.
Col B: Brand Name
Col C: Subscription Tier (gold, silver, platinum which corresponds to states.
Col: E-BD : 51 states.

Data sheet consists of tables for each tier to state.

1. I'd like to be able to pick tier in dropdown ( already enabled via data validation).
2. Id like to be able to display an icon under the states ( Green for Yes, Red for NO)
3. there is a possibility that someone might have a state outside of the tier.. so I should be able to manually edit that one cell for that state to display another ICON so we know it's A'La Carte.

any help is appreciated. If's and Vlookups didnt make sense. Iconsets are all based on 0's and 1's

A125 is the last row for the formula as i have 125 brands.

thank you again for your help!