+ Reply to Thread
Results 1 to 2 of 2

Strange bug with a complex Vlookup

  1. #1
    Registered User
    Join Date
    06-03-2014
    MS-Off Ver
    2013
    Posts
    10

    Angry Strange bug with a complex Vlookup

    Hello,

    I have a Workbook that i have built as a D&D character sheet. Everything is working fine, except for one formula, which is throwing out a very peculiar bug:

    Please Login or Register  to view this content.
    Character Sheet D4 holds the character level, K27 is a comparison to see if they are at the right level for the feat

    If they are, it looks up the level in a named range of levels with various stat modifications, inlcuding feats. For level 20, it returns a blank, when it should return:

    Put your Hands up – First turn of combat, can roll a Charisma Check. Score of 20(not natural) or more means all enemies surrender. Unique enemies require a natural 20
    However it returns a blank. after some investigation, it is the presence of the '20's that's causing problems. if i replace with another number (E.g. 19), or 'Twenty' the formula returns the string fine.

    Does anyone know why?

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Strange bug with a complex Vlookup

    Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

    Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ 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. Bit of a strange one with Vlookup and Iferror
    By johnfash in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-25-2015, 05:37 AM
  2. vlookup strange behaviour . . . why?
    By homasa in forum Excel General
    Replies: 2
    Last Post: 08-23-2010, 11:02 AM
  3. VLOOKUP - Strange results
    By paulwelburn in forum Excel General
    Replies: 6
    Last Post: 05-31-2007, 05:41 PM
  4. Strange vlookup issue
    By s80NL in forum Excel General
    Replies: 3
    Last Post: 02-05-2007, 07:10 PM
  5. [SOLVED] Strange vlookup results
    By Mary-Lou in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 06-01-2006, 10:50 PM
  6. Strange vlookup problem
    By thiver in forum Excel General
    Replies: 4
    Last Post: 05-30-2006, 06:25 PM
  7. [SOLVED] Strange VLOOKUP Problem
    By DMDave in forum Excel General
    Replies: 6
    Last Post: 05-07-2006, 09:06 PM

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