lookup ( input cell , {d1,d2,d3,d4,d5,d6,d7},{r1,r2,r3,r4,r5,r6,r7})


input cell = link the cell where you enter x
d = domain r= range of your all 7 sets of combinations.. try it

else u hv to uplod your sample worbook