IF/OR, logical tests

if i select f column details in c column by dropdown list all other details are change according to f column other details in column c, if i select g column in c column by drop dropdown list all other details are change according to G column other details in column c.

Sample File attached herewith.

Thanks in advance