So I've got something I'm working on right now that I've been suggested to use a VLOOKUP on, and it looks like this:
excel 3.PNG
Right away, my problem is that whenever I type in 8 in the number of stores cell, it automatically returns a value of 0 regardless of what I put in # of compliant stores.
On the other hand, with some of the lower number of stores, it also doesn't display correctly:
excel 4.PNG
See here, with 2 compliant stores / 3 total stores the resulting score should be a 3, but here it returns a 4. Where did things go wrong here?
Bookmarks