Previous Topic Next Topic

Reference table

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

2 responses

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

Similar discussions

How to modify the macro code for new structure of table
jpppol -
TrowaD -

9 responses
VBA code to create Pivot Table
sarisri7 -
ac3mark -

1 response
How to quote sources
Rubens94 -
dwebb -

3 responses
how to convert ounces (oz) to milliliter
JPortillo -
vcoolio -

1 response