I have tried in vain to complete a correct formula for the following:

-----------40x-----43x-----45x-----49x
Group 1......10........20........30........40
Group 2......12........22........32........42
Group 3......14........24........34........44

I will manually type into Cell A1 the group I am using e.g. Group 2 and
into cell A2 the number x e.g. 43x.

Now in cell B1 I want the formula to return the answer 22.

Can anyone point me in the right direction and save me pulling my hair
out???

Thanks


--
CADmanJP