Returning a value based on sub columns

Hi,   I have one table with two different variables, the second variable is split into 4 sub columns       I have two data validation cells that I have set up to look at the first column ...