Lookup returning incorrect result

[btrotter]

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.

 

[Niek Otten]

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


| 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.
|