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 2List AnLIst BnLists A
and B have 10 items eachA1 B1A2 B2........A10 B10If 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