+ Reply to Thread
Results 1 to 6 of 6

Google Spreadsheet-VLOOKUP does not take all characters??

  1. #1
    Registered User
    Join Date
    09-18-2021
    Location
    Sweden
    MS-Off Ver
    Google Spreadsheets/2010
    Posts
    59

    Question Google Spreadsheet-VLOOKUP does not take all characters??

    VLOOKUP only take some characters, why not all?
    In column G:J marked in color it does not take.
    I tried also with "IF formula" only but cant get it worked either

    https://docs.google.com/spreadsheets...it?usp=sharing


    VLOOKUP.png

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,030

    Re: Google Spreadsheet-VLOOKUP does not take all characters??

    The values in col E are all text, whereas some of the values in cols A:D are numbers.
    Not sure if this works in sheets, but try
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    09-18-2021
    Location
    Sweden
    MS-Off Ver
    Google Spreadsheets/2010
    Posts
    59

    Re: Google Spreadsheet-VLOOKUP does not take all characters??

    It didnt worked. I tried to change all "X" to 3 instead but still not working

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,030

    Re: Google Spreadsheet-VLOOKUP does not take all characters??

    Some of the the values in col E are still text

  5. #5
    Registered User
    Join Date
    09-18-2021
    Location
    Sweden
    MS-Off Ver
    Google Spreadsheets/2010
    Posts
    59

    Re: Google Spreadsheet-VLOOKUP does not take all characters??

    Ok, i get it now :-), the cells is in the right format, it toke some time for me to understand that!
    Last edited by KentaTippar; 07-22-2022 at 01:52 PM. Reason: bad spelling

  6. #6
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,030

    Re: Google Spreadsheet-VLOOKUP does not take all characters??

    Glad it's sorted & thanks for the feedback.

+ 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] Google spreadsheet-IF/ISERROR/VLOOKUP cant get it correct
    By KentaTippar in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 05-21-2022, 10:21 AM
  2. [SOLVED] Google Spreadsheet-Number of different characters
    By KentaTippar in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 10-11-2021, 04:50 PM
  3. [SOLVED] Google Spreadsheets- characters in a row
    By KentaTippar in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 19
    Last Post: 09-19-2021, 07:26 AM
  4. Google sheet: Help to attachment file from Google Drive and send email fill in Google Form
    By sbv1986 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 03-01-2021, 10:47 PM
  5. [SOLVED] Vlookup to extract last five characters or include only first 5 characters
    By Michael Lerena in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-10-2017, 04:53 PM
  6. Replies: 0
    Last Post: 07-25-2013, 04:23 PM
  7. [SOLVED] VLOOKUP the middle characters, and ignore the first 3 characters and the last 2
    By bradallen in forum Excel Formulas & Functions
    Replies: 28
    Last Post: 09-18-2012, 04:55 PM

Tags for this Thread

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