Results 1 to 3 of 3

Thread: weird error in vlookup formula

  1. #1

    weird error in vlookup formula

    Register for a FREE account, and/
    or Log in to avoid these ads!


    The sheet I made has some weird error somewhere but I just can't find it. It is supposed to calculate a number depending on different values like object name and level. The first few entries work fine but then it starts to only work for levels around 5 and above. So if I select level 10 it works fine but returns N/A when I choose level 5. The thing is that for the first entries it doesn't matter which level I choose and it works perfectly fine.

    Would be awesome if somebody could help me out here. Maybe I've been starring at it for too long I just can't find the error.


    Thanks in advance

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Excel Version
    Fix the lookup table references


  3. #3
    Thank you its all working now!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts