SB lightning
New Member
- Joined
- Nov 1, 2017
- Messages
- 4
Hi all,
I'm creating a spreadsheet with a list of different names and a rating associated with those names. I have the "master list" in order with the names in column A1-A32 and their rankings in column B1-B32. Now in C1-C50 I have all of those names in the A column but randomly assorted. How can I have column D1-D50 automatically put in that names ranking when that name pops up in a cell in column C?
EX
[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]Al[/TD]
[TD]4[/TD]
[TD]Dan[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Bob[/TD]
[TD]1[/TD]
[TD]Al[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Dan[/TD]
[TD]5[/TD]
[TD]Rick[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Rick[/TD]
[TD]2[/TD]
[TD]Zeus[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Zeus[/TD]
[TD]3[/TD]
[TD]Bob[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Thank you in advance!
I'm creating a spreadsheet with a list of different names and a rating associated with those names. I have the "master list" in order with the names in column A1-A32 and their rankings in column B1-B32. Now in C1-C50 I have all of those names in the A column but randomly assorted. How can I have column D1-D50 automatically put in that names ranking when that name pops up in a cell in column C?
EX
[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]Al[/TD]
[TD]4[/TD]
[TD]Dan[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Bob[/TD]
[TD]1[/TD]
[TD]Al[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Dan[/TD]
[TD]5[/TD]
[TD]Rick[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Rick[/TD]
[TD]2[/TD]
[TD]Zeus[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Zeus[/TD]
[TD]3[/TD]
[TD]Bob[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Thank you in advance!