+ Reply to Thread
Results 1 to 8 of 8

Vlookup Issues

  1. #1
    Registered User
    Join Date
    10-16-2012
    Location
    West Mifflin, PA
    MS-Off Ver
    Excel 2010
    Posts
    12

    Vlookup Issues

    I have a large excel sheet with many tabs and tons of information so I decided to use the Vlookup function to pull my imported data into the correct cells. The "look up" data uses a sequential number starting at 1.1 and ascending from there. My issues happens when I get to 1.10 or 1.20 and so on. The value that gets returned is the one associated with 1.1 and 1.2 respectively. I checked to make sure everything was stored as a number and I tried making sure there were 2 decimal places on the higher numbers but nothing seems to be working. I have created this sheet many times and this is the first time I am encountering this problem. Please, if you have any suggestions, let me know!

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux - O365
    Posts
    12,351

    Re: Vlookup Issues

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

  3. #3
    Registered User
    Join Date
    10-16-2012
    Location
    West Mifflin, PA
    MS-Off Ver
    Excel 2010
    Posts
    12

    Re: Vlookup Issues

    I cannot get the issue to duplicate itself in an example spreadsheet and I cannot disclose the actual spreadsheet due to sensitive information. Would Pictures help? I can take a screen shot of what I am looking at and maybe once you can visualize it you may have suggestions on what I am doing incorrectly?

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux - O365
    Posts
    12,351

    Re: Vlookup Issues

    Perhaps create a small mock up?

  5. #5
    Registered User
    Join Date
    09-27-2015
    Location
    USA
    MS-Off Ver
    2013/Office 365
    Posts
    51

    Re: Vlookup Issues

    Without seeing the issue it could be a decimal place issue. Maybe you have everywhere 1.10 and so on so only show 1 decimal place instead of 2 and that's why 1.10 is returning 1.1 and so on. Pictures would be a start in helping with this.

  6. #6
    Forum Contributor
    Join Date
    06-18-2014
    Location
    USA
    MS-Off Ver
    2013
    Posts
    142

    Re: Vlookup Issues

    It's hard to say without seeing any data, but appears that you are running into the problem where 1.1 is equal to 1.10 as far an Excel is concerned when they are numbers. When they are text, 1.1 does not equal 1.10. Having two decimals on the larger numbers (1.10 and 1.20) only changes what they look like, not their actual value.

    Is your data importing as numbers or as text? If you change your sequential numbers on the data tab to text, and make the higher lookup points 1.10 and 1.20, and the leave the lower ones as 1.1 and 1.2, does that help?

  7. #7
    Registered User
    Join Date
    10-16-2012
    Location
    West Mifflin, PA
    MS-Off Ver
    Excel 2010
    Posts
    12

    Re: Vlookup Issues

    Looks like changing all the number over to text worked. I tried only changing the ones that were causing the issue but it didn't seem to help. After I changed them all from number to text it pulled the correct values from my imported tab. Thank you all so much for the help. It is greatly appreciated!

  8. #8
    Forum Contributor
    Join Date
    06-18-2014
    Location
    USA
    MS-Off Ver
    2013
    Posts
    142

    Re: Vlookup Issues

    Glad to hear it. Please mark this thread as solved if it is all done. You can also click "Add reputation" to thank anyone who you think helped out.

+ 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. VLOOKUP issues
    By BigPeter in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-21-2015, 03:57 PM
  2. VLOOKUP Issues
    By madhatter5 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-18-2014, 11:58 AM
  3. [SOLVED] issues with vlookup
    By grkchakri in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-08-2014, 02:31 AM
  4. [SOLVED] VLOOKUP Issues
    By tapsmiled in forum Excel Formulas & Functions
    Replies: 33
    Last Post: 12-14-2013, 11:01 PM
  5. [SOLVED] Vlookup Issues
    By AndianAtWork in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-03-2013, 02:28 AM
  6. Vlookup issues
    By rhuark in forum Excel General
    Replies: 11
    Last Post: 06-30-2011, 10:50 AM
  7. VLOOKUP issues
    By performrad in forum Excel General
    Replies: 5
    Last Post: 07-19-2010, 11:44 AM

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