Results 1 to 7 of 7

Percentage Vlookup Returning Error / Incorrect Values

Threaded View

  1. #1
    Registered User
    Join Date
    09-13-2021
    Location
    New York, NY
    MS-Off Ver
    365
    Posts
    3

    Percentage Vlookup Returning Error / Incorrect Values

    Hey everyone - been trying to work through this issue and has been driving me crazy!

    In the attached excel, I'm trying to Vlookup a percentage value against a table, where using approximate range lookup returns an incorrect value and exact range lookup returns error.

    The issue is all these percentages are round numbers and the lookup works for a select few values (e.g., 8% works, but not 6%). However, if I go to B10 or I10 and manually enter "6%" it works -- it's extremely strange.

    Let me know what's going on here! Been at it all night and it's driving me insane.

    Thanks!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Vlookup returning incorrect results
    By Informer1111 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-25-2021, 12:00 PM
  2. [SOLVED] Vlookup returning incorrect values in some instnces
    By Howardc1001 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-06-2020, 02:30 AM
  3. Vlookup returning incorrect information
    By Ghost Of Casper in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-10-2013, 12:45 PM
  4. [SOLVED] VLOOKUP returning incorrect results
    By Jennsy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-01-2012, 03:08 PM
  5. VLookup returning incorrect values?
    By hijinxx in forum Excel General
    Replies: 3
    Last Post: 05-24-2012, 05:47 AM
  6. VLOOKUP and MATCH returning incorrect values
    By -Spax- in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 10-10-2011, 07:03 AM
  7. VLOOKUP returning incorrect values for unfound match
    By scaffdog845 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-15-2010, 01:30 PM

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