Comments on: If VLOOKUP in Google Sheets is not working

How to do a vlookup without errors in Google Sheets? Take a closer look at the most common mistakes made when working with the VLOOKUP function. Continue reading

Comments page 2. Total comments: 48

  1. Greetings,
    I run into an odd problem. Consider 2 columns X 9 row of text data, first column names, second family name. If I search using the name I get the following: first name return last family name, 2nd returns 2nd, 3rd returns 3rd, 4th returns last, 5th and 6th return last, 7th and 8th return and error and last returns 3rd!! Try to make sense of that?!?

    1. Just got my answer: The data was not sorted...I can'T sort the data everytime I wonder How I can fix this.

  2. thank you too match
    I benefited from it

  3. Hi all,
    Please help!
    I'm using vlookup and it's working for half of my values - for numbers 1-96 it gives me a value , but then gives me an error for any values about 97, even though the formula is exactly the same and the chart has all numbers from 1-160. any ideas as to why?

    1. Hi Chloe,

      I'm afraid it's hard to tell what's going wrong without seeing the structure of your table and the data you use there. Please consider sharing your file with us (support@4-bits.com) with your source data and the result you expect to get.

      Note. We keep that email for file sharing only, please do not email there. Once you share the file, just confirm by replying here.

  4. Thank you for helping out my 1-hour frustration!

  5. I am using VLOOKUP and it is working perfectly except that the hyperlink isn't carrying over anymore. I work at a school and I set up the google sheets as I did last year, the hyperlinks carried over and are still working. Can you help?

    1. To be clear the hyperlinks that are working are from the sheets that I set up last year.

      1. Nikki,

        could you please specify if your hyperlinks are in the same file where you try to reference them? Or if you're trying to pull them from a completely different file?

  6. Hi, I cannot get VLOOKUP to work in sheets. If I import an excel file with exactly the same formula to sheets it works perfectly, but if I put the same formula into the google sheets version of the documentis gives me a parse error. I think it may have something to do with regional configurations as I am in Argentina, but use sheets in English. I have also tried using the spanish formula BUSCARV which made no difference.
    Any thoughts?
    Thanks,
    Ed

    1. Hermano! Do the query in a column and return a value in a column "after" the lookup column, like =VLOOKUP(A1, A3:B10, 2, FALSE). It did not worked while I was using column "1" as return value. At least this worked for me. If this is the case.

    2. Hi Ed,

      Open File > Spreadsheet settings in the Google Sheets menu and set a locale that you'd like to use.
      Once set, please enter the formula again with correct symbols that separate arguments (commas or semicolons, you'll see the required symbols in the formula hint).

      Your VLOOKUP should work then.

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)
Find and replace in values, formulas, errors, links, and notes
Calculate cells based on their colors
Switch between different text cases
Transform your crosstab table to a flat list
Lock top rows and left columns
Unmerge all cells in the selection
Flip adjacent cells, rows, or columns
Find duplicate or unique rows in your sheet
Compare columns or sheets for duplicates
Find duplicate or unique cells in your sheet
Join values in the selected cells, rows, or columns
Update data in the main table with the info from the lookup table
Combine duplicate rows and merge unique data referring to the same record
Combine data from multiple sheets into one
Manage tex in different ways
Apply lower, upper, sentence case; toggle and capitalize cells
Insert text to any position in selected cells
Replace accented characters, symbols, and codes
Remove all unwanted characters
Delete multiple substrings or individual characters
Get rid of extra spaces and delimiters
Erase characters by their position in selected cells
Eliminate all blank and unused rows and columns
Сlear data by type
Split values to columns by any character or a string
Divide text from one cell into multiple columns
Pull records apart by position
Separate first and last names; pull titles, salutations, and other name units
Convert relative to absolute and back, replace formulas with values, modify all formulas at once
Turn text to number and date format, export data to JSON or XML
Fill the range with random passwords, dates, numbers, custom values, or booleans
Shuffle the selected cells, rows, or columns
Find and replace in values, formulas, errors, links, and notes
Calculate cells based on their colors
Switch between different text cases
Transform your crosstab table to a flat list
Lock top rows and left columns
Unmerge all cells in the selection
Flip adjacent cells, rows, or columns
Find duplicate or unique rows in your sheet
Compare columns or sheets for duplicates
Find duplicate or unique cells in your sheet
Join values in the selected cells, rows, or columns
Update data in the main table with the info from the lookup table
Combine duplicate rows and merge unique data referring to the same record
Combine data from multiple sheets into one
Manage tex in different ways
Apply lower, upper, sentence case; toggle and capitalize cells
Insert text to any position in selected cells
Replace accented characters, symbols, and codes
Remove all unwanted characters
Delete multiple substrings or individual characters
Get rid of extra spaces and delimiters
Erase characters by their position in selected cells
Eliminate all blank and unused rows and columns
Сlear data by type
Split values to columns by any character or a string
Divide text from one cell into multiple columns
Pull records apart by position
Separate first and last names; pull titles, salutations, and other name units
Convert relative to absolute and back, replace formulas with values, modify all formulas at once
Turn text to number and date format, export data to JSON or XML
Fill the range with random passwords, dates, numbers, custom values, or booleans
Shuffle the selected cells, rows, or columns
Find and replace in values, formulas, errors, links, and notes
Calculate cells based on their colors
Switch between different text cases
Transform your crosstab table to a flat list
Lock top rows and left columns
Unmerge all cells in the selection
Flip adjacent cells, rows, or columns
Find duplicate or unique rows in your sheet
Compare columns or sheets for duplicates
Find duplicate or unique cells in your sheet
Join values in the selected cells, rows, or columns
Update data in the main table with the info from the lookup table
Combine duplicate rows and merge unique data referring to the same record
Combine data from multiple sheets into one
Manage tex in different ways
Apply lower, upper, sentence case; toggle and capitalize cells
Insert text to any position in selected cells
Replace accented characters, symbols, and codes
Remove all unwanted characters
Delete multiple substrings or individual characters
Get rid of extra spaces and delimiters
Erase characters by their position in selected cells
Eliminate all blank and unused rows and columns
Сlear data by type
Split values to columns by any character or a string
Divide text from one cell into multiple columns
Pull records apart by position
Separate first and last names; pull titles, salutations, and other name units
Convert relative to absolute and back, replace formulas with values, modify all formulas at once
Turn text to number and date format, export data to JSON or XML
Fill the range with random passwords, dates, numbers, custom values, or booleans
Shuffle the selected cells, rows, or columns