Avatar

Level 1

Hello Everyone,

Could you please help to solve this puzzle.

I need to make a value of cells in the 2nd column dependent on the selection made in the cells in the 1st column, i.e.:

Header 1Header 2
List AnLIst Bn


Lists A and B have 10 items each

A1    B1

A2    B2

........

A10  B10

If A1 is selected I need a B1 appear in the second column in the same row, if A2 selected then B2,...and so on.

Could you please hep to resolve this, if at all this is possible?

Many thanks,

Andrew