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

Table of contents

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 :)