Find a value in a column based on a pre defined set of values

Hi,

I have a predefined set of values. One value from this set appears in a column on a given day with "#N/A" being returned in the other rows. This changes everyday and a different vaue from the same set can appear in the same column but in a different row with "#N/A" in the other rows. I am looking for a formula that would identify the value in that column on any particular day. Please see the attached simplified sample worksheet where A,B and C are the possible values that are returned in column C as the value changes in the cell B2. I want this formula for the cell I4.

Thanks!