weird error in vlookup formula

letrero

New member
Joined
Mar 4, 2015
Messages
2
Reaction score
0
Points
0
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.

View attachment dragon_mania_legends-1-1.xlsx


Thanks in advance
 
Fix the lookup table references

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