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.

Reference table
School time table software free download full version - Download - Organisation and teamwork
How to delete part of a table in word - Guide
Ascii table c++ - Guide
Html table fit to screen - Guide
Pivot table date format mm/dd/yyyy - Guide

2 responses

Answer 1 / 2

mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 166
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})

Marvellus
Apr 29, 2009 at 06:18 AM

Thanks. Worked beautifully.

Marvellus
Jun 15, 2009 at 04:02 AM

Hi Aziz,
Can I please send you my Excel sheet to ask for a few more tips?
Thanks you.
Marcellus

Answer 2 / 2

mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 166
Jun 15, 2009 at 04:06 AM

Sure you can share .... or PM me ....

Subscribe To Our Newsletter!