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
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.
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:
- 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
- Back alley table - Download - Adult games
2 responses
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
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})
=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})
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
Jun 15, 2009 at 04:06 AM
Sure you can share .... or PM me ....
Apr 29, 2009 at 06:18 AM
Jun 15, 2009 at 04:02 AM
Can I please send you my Excel sheet to ask for a few more tips?
Thanks you.
Marcellus