Results 1 to 4 of 4

vlookup returning n/a can't solve!!!

Threaded View

  1. #1
    Registered User
    Join Date
    12-29-2009
    Location
    Wilkes-Barre, PA
    MS-Off Ver
    Excel 2003
    Posts
    26

    vlookup returning n/a can't solve!!!

    I have a vlookup formula that is looking up an attainment percent in column I and referencing it against a table to return another percentage. The lookup works for all attainments, except for when it is attempting to lookup the value of 113%. I am using roundup formulas in column I, and that formula seems to be the issue. When i manually enter 113% - the lookup will work. Something is off and I just can't tell what it is. Row 9 is where i am having the issue. Change cell I 9 manually to 113% and you see that the lookup works, when i use the formula to calculate the attainment %, and round it up to 113% - it does not work.

    HELP!
    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] Need Help with Vlookup and Index Functions to Solve for Error
    By trandle in forum Excel General
    Replies: 13
    Last Post: 05-22-2015, 05:25 PM
  2. [SOLVED] How to use VLOOKUP to solve this
    By cory0789 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-27-2014, 11:23 PM
  3. Help with Vlookup / Hlookup (or anythning else that will solve problem!)
    By stephen.m.brown in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-22-2013, 09:53 AM
  4. [SOLVED] can vlookup solve this?
    By cflyte in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-01-2013, 03:52 AM
  5. [SOLVED] Please help about vlookup function.. Or other to solve the stiuation
    By dalipsinghbisht in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 01-09-2013, 01:44 PM
  6. Cannot solve vlookup/mid function problem...
    By kimchi123 in forum Excel General
    Replies: 4
    Last Post: 06-30-2011, 12:22 PM
  7. Can't solve this with Vlookup, what do I need and how to use it?
    By RCG in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-03-2010, 11:09 AM

Tags for this Thread

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