I use the function VLOOKUP($C$7,EmployeeData,2) in cell c8 in sheet1 to pull
the second column(EmployeeNumber) from the employees sheet(EmployeeName,
EmployeeNumber, DepartmentNumber) when the cell c7(EmployeeName) is selected
in the combox. Here "employeedata" is a namerange defined big enough to hold
the data in employees sheet.

In the begining, there are 23 rows in the Employees sheet and this formula
works, anytime in sheet1 the "EmployeeName" is selected in the combox c7 and
the corresponding EmployeeNumber is showing up in c8. But after inserting a
row(employee record) in the employees sheet, sort the sheet. The vlookup
function does not work for the row after 23rd. the cell in formula
VLOOKUP($C$7,EmployeeData,2) is just empty, even without a error code
returned.

This drove me crazy and do not understand why the function works for the
data in 1-23 rows but not for any new rows? The sheet is sorted already. Oh,
my neck is sore, any clues? I would appreciate.