weird vlookup error

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.

Thanks in advance

AttachmentSize
dragon_mania_legends-1-1.xlsx17.3 KB
Nick's picture

change formula in D3 to

change formula in D3 to this:
=VLOOKUP(B3,lists!B:C,2,0)*VLOOKUP(C3,lists!E:F,2,0)

and copy it down