Hi
So I know that VLOOKUP Uses the first column to search for a value and
then looks to columns to its right for the return value.
LOOKUP allows for any columns to be used for the search value and any
other column for the return value.
I have used LOOKUP but am receiving errors with the return values
because the Search Value Column is not sorted.
I have a file with employee numbers and names and other information
that need to be sorted by number and another workbook which is for
input but the input is by employee name and I want the employee number
to show up automatically.
Using LOOKUP I'm getting some wrong values due to the simple fact that
the employee names are not sorted alphabetically in the previous
workbook.
Is there a fix for this? Or a better way to have the employee number
automatically inputted when the name is entered?

Thanks For your help.