I am creating a spreadsheet for a fantasy sport that will allow me to look at
the order that I think players are ranked compared to their average draft
position. However, I have one spreadsheet that has all my player rankings
and another that lists their average draft position(ADP). Since the order of
players differs from their ADP it will take forever to insert each ADP for
each player manually. Is their a formula I can use? Here is an example:
Spreadsheet 1 Spreadsheet 2
(Ranking of players) (Average Draft Position)
Name (B) ADP (C) Name (B) ADP (C)
Player 1 ? Player 8 1.01
Player 2 ? Player 3 1.02
Player 3 ? Player 15 1.03
Player 4 ? Player 1 1.04
Player 5 ? Player 2 1.05

Is there a formula that I can type in SPreadsheet 1, Cell C1 that will Look
in Spreadsheet 2, Column 'B' for a name that matches the name in Cell B1 in
Spreadsheet 1? Then copy the information from Cell C1 in Spreadsheet 2 into
Cell C1 in Spreadsheet 1. Sorry for any confusion, but I would greatly
appreciate any help.
FYI - Spreadsheet 1 is my master sheet and I wasn't able to find a site that
provided both statistical performance and ADP on the same chart. Otherwise I
would have just used the sort command.