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
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
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?Originally Posted by rad1964
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.
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".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks