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
Attachment | Size |
---|---|
dragon_mania_legends-1-1.xlsx | 17.3 KB |
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