Spreadsheet: 889909d1740940020-xlookup-and-vlookup-doesnt-seem-to-work-test
Sheet: Sheet3

Name.1 | Name.2 | GP | Player Skill Rating | Arena Rank | Fleet Rank | Role
tjcc9269 _x000D_ | [NAME] | 14126155 | 3,143 - Kyber 3 | 275 | 193 | Member
HOME6 _x000D_ | Yub Nub | 13284183 | 3,246 - Kyber 3 | 42 | 6 | Member
Gryphon _x000D_ | Fate Duelist | 13103776 | 3,351 - Kyber 2 | 2 | 15 | Officer
Maximum Zach Mini _x000D_ | Beastmaster | 12995815 | 3,523 - Kyber 2 | 3 | 2 | Member
DŁ FCME _x000D_ | Punisher | 12966317 | 3,195 - Kyber 3 | 95 | 38 | Member
Newmania _x000D_ | Loyal Friend | 12955779 | 3,518 - Kyber 2 | 20 | 12 | Officer
sir5centalot _x000D_ | [NAME] | 12728424 | 3,316 - Kyber 2 | 141 | 24 | Member
[NAME] _x000D_ | Scum | 12674825 | 3,551 - Kyber 2 | 15 | 13 | Member
[NAME] _x000D_ | I Survived Order 66 | 12598981 | 3,369 - Kyber 2 | 41 | 6 | Officer
Kymbo _x000D_ | Much to Learn | 12597235 | 2,921 - Kyber 5 | 157 | 101 | Member
TK11051 _x000D_ | Vader's Fist | 12588205 | 3,482 - Kyber 2 | 125 | 3 | Member
[NAME] _x000D_ | Tactical Genius | 12574353 | 3,352 - Kyber 2 | 51 | 31 | Member
[NAME] _x000D_ | Penchant for Destruction | 12536825 | 3,241 - Kyber 3 | 99 | 10 | Member
T Pow _x000D_ | I Am No Jedi | 12424156 | 3,352 - Kyber 2 | 85 | 15 | Member
[NAME] _x000D_ | Meatbag | 12335832 | 3,143 - Kyber 3 | 59 | 19 | Member
Rockzor _x000D_ | Memorialized | 12262212 | 3,471 - Kyber 2 | 15 | 1 | Member
Barzhak the Great _x000D_ | Hired Gun | 12200087 | 3,094 - Kyber 4 | 99 | 12 | Officer
WhoisThisGuy314 _x000D_ | Seduced by the Dark Side | 12196899 | 2,951 - Kyber 5 | 186 | 4 | Member
MINI BriMan1994 _x000D_ | [NAME] | 12183280 | 3,454 - Kyber 2 | 70 | 2 | Member
[NAME] _x000D_ | [NAME] | 12142630 | 3,293 - Kyber 3 | 66 | 16 | Member
elderjl24 _x000D_ | Tactical Genius | 12139308 | 3,325 - Kyber 2 | 4 | 14 | Member
[NAME] _x000D_ | Obtainer of Rare Things | 12105206 | 3,327 - Kyber 2 | 69 | 8 | Member
APDarthLucius2326 _x000D_ | [NAME] | 12056616 | 3,163 - Kyber 3 | 72 | 31 | Officer
jedidrummer09 _x000D_ | Okeeday, Booma | 11915414 | 3,164 - Kyber 3 | 106 | 9 | Leader
Flareb00t _x000D_ | Trapped In Carbonite | 11872963 | 3,564 - Kyber 2 | 3 | 3 | Member
Jasem Thfar _x000D_ | Noble | 11849019 | 2,986 - Aurodium 1 | 92 | 5 | Member
Nizuya _x000D_ | Challenger | 11809409 | 3,126 - Kyber 4 | 309 | 13 | Member
Crashster _x000D_ | Grizzled Veteran | 11745445 | 2,597 - Aurodium 5 | 54 | 38 | Member
Issy _x000D_ | Sith Eternal | 11685422 | 3,385 - Kyber 2 | 2 | 11 | Member
Mechman2000 _x000D_ | Persistent | 11679265 | 2,598 - Chromium 2 | 109 | 29 | Member
Cheers _x000D_ | Awakened | 11618269 | 3,218 - Kyber 3 | 105 | 4 | Member
[NAME] _x000D_ | Vader's Fist | 11551240 | 3,212 - Kyber 3 | 61 | 8 | Member
[NAME] _x000D_ | Tactical Genius | 11461942 | 3,167 - Kyber 3 | 4 | 4 | Officer
RemoveDatacrons Cad _x000D_ | Shadow | 11422931 | 3,129 - Kyber 4 | 69 | 17 | Member
MINI ObiRonKenobi _x000D_ | Scum | 11413276 | 3,142 - Kyber 3 | 42 | 20 | Member
Legendary _x000D_ | Champion | 11382396 | 3,183 - Kyber 3 | 70 | 2 | Member
Tyrannus _x000D_ | I Survived Order 66 | 11330290 | 3,275 - Kyber 3 | 93 | 9 | Member
Fainsan _x000D_ | Holotable Hero | 11315270 | 2,260 - Bronzium 3 | 206 | 72 | Member
[NAME] _x000D_ | The Better General | 11264504 | 3,168 - Kyber 3 | 63 | 15 | Member
Mcdrunk _x000D_ | Beastmaster | 11176166 | 2,613 - Chromium 2 | 132 | 9 | Member
JJKalsu _x000D_ | Skiff Guard | 11155645 | 3,190 - Kyber 3 | 242 | 8 | Member
Chaptastick _x000D_ | Criminal | 11056026 | 3,095 - Kyber 4 | 463 | 12 | Member
MINI LukeJM _x000D_ | Loved | 11041623 | 3,562 - Kyber 2 | 1 | 12 | Officer
Kells _x000D_ | Captain | 10987806 | 2,922 - Kyber 5 | 225 | 22 | Member
KingHawkeyes _x000D_ | General | 10917861 | 2,582 - Aurodium 5 | 211 | 48 | Member
Luffman816 _x000D_ | Beastmaster | 10788032 | 2,777 - Aurodium 3 | 209 | 97 | Member
MINI Gabe Galaxyroamer _x000D_ | Hello There | 9936080 | 2,537 - Chromium 3 | 129 | 79 | Officer
Waggs _x000D_ | Baron-Administrator | 9725152 | 2,660 - Aurodium 4 | 12 | 14 | Member
[NAME] _x000D_ | [NAME] | 9491489 | 2,788 - Aurodium 3 | 178 | 254 | Member
 |  |  |  |  |  |  | Mini LukeJM