Reference table [Closed]

Report
-
mubashir aziz
Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
-
Hello,
I would like to reference a table which contain in the first column positions 1 to 15 and in the second column points awarded to each of the 15 positions.
Then for example if I type in cell A1 any one of the 15 positions, cell B1 should automatically populate the respectively assigned points e.g. A1 1 and B1 25, A2 2 B2 20, A3 3 B3 16, A4 4 B4 13, etc.
Thanks for any help.

2 replies

Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
210
Insert this formula in Cell B1 and enter any value in A1

=LOOKUP(A1,{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15},{30,29,28,27,26,25,20,15,14,13,12,11,10,5,4})
Thanks. Worked beautifully.
Hi Aziz,
Can I please send you my Excel sheet to ask for a few more tips?
Thanks you.
Marcellus
Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
210
Sure you can share .... or PM me ....