Why does my Excel lookup return a name for an item code that isn't in the table?
TechnologyI entered a new kit code in our Excel checkout sheet and a familiar item name appeared beside it. The code hasn't been added to the reference table yet. A colleague said a result without an error meant the lookup had found the item.
The formula uses VLOOKUP, and I left out its last argument when copying the example. We need each code to identify that exact item; a nearby code isn't an acceptable substitute.
How should I correct this before we use the sheet at the desk? I'd rather have a missing item clearly flagged than a convincing-looking description attached to the wrong code, but the colleague wants to keep the sheet free of error messages.