A1
A2
A3
A4
A5
B1
B2
B3
I want the formula to assign the values in the second column below when a line selection is made and display it on the form or view.
A1 10
A2 8
A3 6
A4 4
A5 2
B1 4
B2 2
B3 1
Is a formula the correct vehicle for accomplishing this? If so how should the formula read?