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...

Hi thereI am creating a Purchase order form with many (11) columns  so I have no more space to insert  a column which will show the result of "Quantity x Price". (Then it would be simple to get a subtotal at the bottom of that extra column by using Sum function from FormCalc.)So I would like to have...