Using MS Office Professional 2003
Given:
Four columns (A-D) titled ID, Name, Job, Job Description
Data range is A2:D158
Data is sorted alphabetically by last name:

ID Name Job Job Description
502733 Baker,Mark DIR VP MFG
502160 Jones,Debra DIR VP Finance
501565 Michaels,Susan DIR VP MKTG
504729 Smith,David DIR VP Technology

I have four names on the same sheet that already appear on the list. They
are listed from A:164:A167 in random alphabetical order by last name.

I want to search the data range referenced above and populate the ID number
in column B and Job Description in column C for my individuals names.

Formula for ID: =INDEX(A2:A158,MATCH(A164,$B$2:$B$158,TRUE),1)
Formula for Job Description: =LOOKUP(A164,$B$2:$D$158)

Problem: The formulas work for cells A164 and A165. Cells A166 and A167
return the ID number and Job Description listed for the individual appearing
one row before my individual in the data range. In other words, my
individuals information is listed in row 38 and the formula is returning the
information for row 37.

I dont understand why this is happening or how to resolve it. Help is much
appreciated!

Cynthia

--
Cynthia