Home | Webstore
Latest News: OOTP Update 20.5.47 - OOTP 20 Available - FHM 5 Available

Collection Missions for Perfect Team Released!

  

Go Back   OOTP Developments Forums > Out of the Park Baseball 20 > OOTP Mods > OOTP Mods - Database Tools

OOTP Mods - Database Tools Do you need to take a dump? SQL gurus welcome

Reply
 
Thread Tools
Old 05-09-2018, 10:08 PM   #1
TwinsGuy11
Minors (Triple A)
 
Join Date: Feb 2015
Posts: 208
Thanks: 52
Thanked 79x in 49 posts
Help With Vlookup in Excel

Hey I need help. I'm trying to do a vlookup with a stat file from a dynasty and then stats from baseball reference.

I must b e missing something super simple, but why can't I get anything in column a to match with column b. I'm aware of some extra characters in column b and not all players are present, but I know Aaron Judge is in both and I just keep getting #N/A.
Attached Files
File Type: csv test.csv (19.9 KB, 88 views)
TwinsGuy11 is offline   Reply With Quote
Old 05-09-2018, 11:32 PM   #2
Timofmars
Minors (Double A)
 
Join Date: Feb 2018
Posts: 170
Thanks: 64
Thanked 57x in 40 posts
Seems like the space between first and last names in the 2nd column is not actually the same space as the 1st column. It seems to be no-break space
Timofmars is offline   Reply With Quote
Thank you for this post:
TwinsGuy11 (05-10-2018)
Old 05-10-2018, 11:45 AM   #3
TwinsGuy11
Minors (Triple A)
 
Join Date: Feb 2015
Posts: 208
Thanks: 52
Thanked 79x in 49 posts
Quote:
Originally Posted by Timofmars View Post
Seems like the space between first and last names in the 2nd column is not actually the same space as the 1st column. It seems to be no-break space
You're a genius! I can use the substitute function to swap out for a space and then vlookup. Thanks so much!
TwinsGuy11 is offline   Reply With Quote
Reply

Bookmarks

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 08:03 PM.

 

Major League Baseball trademarks and copyrights are used with permission of MLB Advanced Media, L.P. Minor League Baseball trademarks and copyrights are used with the permission of Minor League Baseball. All rights reserved.

The Major League Baseball Players Association (www.MLBPLAYERS.com ) is the collective bargaining representative for all professional baseball players of the thirty Major League Baseball teams and serves as the exclusive group licensing agent for commercial and licensing activities involving active Major League baseball players. On behalf of its members, it operates the Players Choice licensing program and the Players Choice Awards, which benefit the needy through the Major League Baseball Players Trust, a charitable foundation established and run entirely by Major League baseball players. Follow: @MLB_Players; @MLBPAClubhouse; @MLBPlayersTrust

Out of the Park Baseball is a registered trademark of Out of the Park Developments GmbH & Co. KG

Google Play is a trademark of Google Inc.

Apple, iPhone, iPod touch and iPad are trademarks of Apple Inc., registered in the U.S. and other countries.

COPYRIGHT © 2017 OUT OF THE PARK DEVELOPMENTS. ALL RIGHTS RESERVED.

 

Powered by vBulletin® Version 3.8.10
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Copyright © 2018 Out of the Park Developments