When using the €œLook-up€� formula for €œLookup value, lookup vector, result
vector option€�, if an item description (lookup value) on my current file is
not found in my item chart file (2nd file), the incorrect item category (in
the 2nd file) result may be returned instead of a €œN/A€� (or error, etc). I
would rather that the result be an error of some sort than the wrong value.
Am I doing something wrong, or is that the way the function is supposed to
work?


Note: The Item Chart is sorted by Item Description, alpha ascending. (When
it wasnt sorted, the item category pertaining to the last item on the list
was being returned. Right now, I think it is returning a result for the item
near where the missing tem should be on the list.