This behavior is as specified in HELP
Don't use Lookup, use Vlookup (or Hlookup) with the 4th argument set to FALSE

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"btrotter" wrote in message ...
| 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 wasn't 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.
|