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!

    Hey

    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.

    dragon_mania_legends-1-1.xlsx


    Thanks in advance

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,828
    Articles
    0
    Excel Version
    O365
    Fix the lookup table references

    =VLOOKUP(B3,lists!$B$1:$C$88,2,0)*VLOOKUP(C3,lists!$E$2:$F$51,2,0)

  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
  •