• How to vlookup in Excel
    2007/2010/2013/2016
  • How to vlookup
    between two sheets
  • 13 Reasons Why Your
    Vlookup is not Working
  • Vlookup Between Two
    Workbooks

Select Page

8 common problems with vlookups

Posted by Analyst | Sep 27, 2012 | Uncategorized | 13 |

Share:

Rate:

NextHow to do a vlookup in Excel 2003

About The Author

Analyst

Analyst

Related Posts

How to vlookup in Excel 2007/2010

How to vlookup in Excel 2007/2010

September 12, 2013

How to do a vlookup in Excel 2003

How to do a vlookup in Excel 2003

October 16, 2012

Vlookup Between Two Workbooks

Vlookup Between Two Workbooks

September 2, 2013

13 Comments

  1. stuti singh
    stuti singh on March 28, 2014 at 2:07 am

    the way solutions& errors are mentioned is fabulous………& ofcourse thanks

    Reply
  2. Prince
    Prince on March 22, 2014 at 6:09 am

    Very Nice and Up to the Mark . A step by step solution.

    Reply
  3. Joseph
    Joseph on March 19, 2014 at 11:47 am

    This is great! I have not read the entire tutorial, but I found the fix for common problem number 5 (use general format instead of text format) to be very, very useful when downloading SharePoint lists to Excel files on my local PC.

    It was driving me nuts because I tried to create a VLOOKUP in an inserted column, but apparently all of the spreadsheet (when downloading from SharePoint) is considered text? Maybe? I would just see the formula, not the VLOOKUP value!

    Changing the format to general did the trick! Thanks!

    Reply
    • Analyst
      Analyst on March 20, 2014 at 8:21 pm

      Awesome – glad I could help!

      Reply
  4. Noor
    Noor on January 12, 2014 at 10:45 am

    very very useful tutorial for vlookup. Thanks

    Reply
  5. Cheri
    Cheri on January 8, 2014 at 7:35 pm

    Thank you. This information is easy to understand with examples of errors and solutions. I was able to follow this to resolve my lookup problems. Thanks again!

    Reply
    • Analyst
      Analyst on January 8, 2014 at 8:36 pm

      You’re welcome.

      Reply
  6. Part
    Part on December 19, 2013 at 12:39 pm

    very interesting tutorial, it has helped me to learn how to use vlookup to compare data

    Reply
  7. Dale
    Dale on December 17, 2013 at 9:37 pm

    Hello, I would like to say your site is very informative, thank you. However I have a question for you. I’m trying to use vlookup to find data on one worksheet and populate the result in another, is this possible? However my return data is text not numbers. I want it to look up time slot and tell me is an employees was working that particular day.

    Reply
    • Analyst
      Analyst on December 18, 2013 at 7:47 pm

      Hi

      Yes – it is possible to get data from one sheet into another – there’s a tutorial on that here: https://howtovlookupinexcel.com/vlookup-between-two-workbooks

      In terms of your question about text, yes, that’s also possible, but the text data in both worksheets will need to match exactly eg if you had “Alex” in one worksheet but had “Alex.” in the other and you were trying to get results for “Alex” using the vlookup, it wouldn’t work, as the data doesn’t match. You can try the vlookup with words in the file I provide on this site – the format of the names is exactly the same, so you can see for yourself that it does work with text. Hope that helps.

      Reply
  8. sakshi jain
    sakshi jain on December 14, 2013 at 9:28 am

    its very useful as each and every step is clear and made easy to understand

    Reply
  9. Teri Nimmo
    Teri Nimmo on December 9, 2013 at 4:01 pm

    So cool. Thank you, I would’ve never come up with the solution without help from this page.

    Reply
    • Analyst
      Analyst on December 9, 2013 at 8:27 pm

      You’re welcome.

      Reply
7-day free trial

Excel Tutorials | Learn Excel

Leave a reply Cancel reply

Your email address will not be published. Required fields are marked *

"It's here! A step by step Pivot Table Tutorial

Designed by Elegant Themes | Powered by WordPress