Creating a table based on rank
Hi, I have a list of 13 names in one column and in the adjacent column a score for each one. Based on this score I have ranked them 1-13 in another column. On a different worksheet I have a column with 1-13 listed in decending order. I would like to populate the column adjacent to this with the name that corresponds to the same rank on the other spreadsheet. A small example as follows: Spreadsheet 1: Rank Name Score 2 Apple 13 4 Orange 2 1 Grape 15 3 Pear 10 Spreadsheet 2 (should look like this):- Rank Name 1 Grape 2 Apple 3 Pear 4 Orange Many thanks in advance if any of you can help. Regards, GW -- giantwolf ------------------------------------------------------------------------ giantwolf's Profile: http://www.excelforum.com/member.php...o&userid=24718 View this thread: http://www.excelforum.com/showthread...hreadid=499531 |
Creating a table based on rank
A vlookup should work.
=vlookup(a1, sheet1!a1:b13, 2, false) "giantwolf" wrote: Hi, I have a list of 13 names in one column and in the adjacent column a score for each one. Based on this score I have ranked them 1-13 in another column. On a different worksheet I have a column with 1-13 listed in decending order. I would like to populate the column adjacent to this with the name that corresponds to the same rank on the other spreadsheet. A small example as follows: Spreadsheet 1: Rank Name Score 2 Apple 13 4 Orange 2 1 Grape 15 3 Pear 10 Spreadsheet 2 (should look like this):- Rank Name 1 Grape 2 Apple 3 Pear 4 Orange Many thanks in advance if any of you can help. Regards, GW -- giantwolf ------------------------------------------------------------------------ giantwolf's Profile: http://www.excelforum.com/member.php...o&userid=24718 View this thread: http://www.excelforum.com/showthread...hreadid=499531 |
Creating a table based on rank
You're absolutely right. Thanks. GW -- giantwolf ------------------------------------------------------------------------ giantwolf's Profile: http://www.excelforum.com/member.php...o&userid=24718 View this thread: http://www.excelforum.com/showthread...hreadid=499531 |
All times are GMT +1. The time now is 03:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com