Reference table

Closed
Marvellus - Apr 27, 2009 at 07:34 AM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - Jun 15, 2009 at 04:06 AM
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

mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 160
Apr 29, 2009 at 05:44 AM
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})
0
Thanks. Worked beautifully.
0
Hi Aziz,
Can I please send you my Excel sheet to ask for a few more tips?
Thanks you.
Marcellus
0
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 160
Jun 15, 2009 at 04:06 AM
Sure you can share .... or PM me ....

0