+ Reply to Thread
Results 1 to 6 of 6

From Excel working to Google Sheets no longer working

  1. #1
    Registered User
    Join Date
    07-12-2016
    Location
    California
    MS-Off Ver
    2010
    Posts
    8

    From Excel working to Google Sheets no longer working

    My formula worked until recently in Google Sheets, what gives?

    =vlookup($E2,Players!$A$2:$P$489,5,false)

    I attached the spreadsheet that works in excel. Maybe some expert can tell me how to make this work in Google Sheets?!

    On the highlights tab, I put in the ID and the players name populates, as well as the division (A,B,C or D)

    thanks,
    rad1964
    Attached Files Attached Files

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, Office 365
    Posts
    12,025

    Re: From Excel working to Google Sheets no longer working

    I don't do Google sheets, but a quick reading of this Google support page tells me your formula should work fine just as it does in the Excel upload.

    https://support.google.com/docs/answer/3093318?hl=en

    When you say it's not working how exactly is it not working?
    Dave

  3. #3
    Registered User
    Join Date
    07-12-2016
    Location
    California
    MS-Off Ver
    2010
    Posts
    8

    Re: From Excel working to Google Sheets no longer working

    When you enter a number (ID) in Highlights TAB in the ID column it should auto-populate the Player Name field, for instance ID# 199 = Robert Adams (reading from the Players TAB)

  4. #4
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, Office 365
    Posts
    12,025

    Re: From Excel working to Google Sheets no longer working

    Quote Originally Posted by rad1964 View Post
    When you enter a number (ID) in Highlights TAB in the ID column it should auto-populate the Player Name field, for instance ID# 199 = Robert Adams (reading from the Players TAB)
    OK. So your Excel file does that fine. What does it return in Google sheets?

  5. #5
    Registered User
    Join Date
    07-12-2016
    Location
    California
    MS-Off Ver
    2010
    Posts
    8

    Re: From Excel working to Google Sheets no longer working

    absolutely nothing.
    type in an ID nothing happens.
    I tried after finding that it worked when I downloaded to re-upload and it did not do anything.

  6. #6
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, Office 365
    Posts
    12,025

    Re: From Excel working to Google Sheets no longer working

    Hmm.

    Unless someone familiar with Google sheets responds here the only thing I can suggest is to Google "Google sheets forums" and see what shows up.

    In the meantime I'll try sending up a "help flare".

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Importdata stopped working (google excel)
    By Ditch1983 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 01-11-2016, 04:37 AM
  2. [SOLVED] Excel to PPT - VBA no longer working with 2013
    By Jissenka in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-12-2015, 05:57 PM
  3. website hyperlinks no longer working in Excel
    By robert harris in forum Excel General
    Replies: 2
    Last Post: 06-11-2013, 04:33 PM
  4. Macro to create new sheets based on template no longer working
    By pauldaddyadams in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-16-2012, 03:51 PM
  5. Excel features mysteriously no longer working
    By GordonPSmith in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-18-2011, 03:58 PM
  6. Routine no longer working in Excel Module?
    By meridian2000 in forum Excel Programming / VBA / Macros
    Replies: 37
    Last Post: 06-17-2009, 09:20 AM
  7. Help: Excel 4 macro suddenly no longer working
    By Keske Saram in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-03-2005, 10:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1