I created a Travel Expense form for my small company. I want values to be
filled in automatically once the person types in their Name on the first
worksheet. (Name is filled in via a drop down list in B2. All Reference data
is on additional sheets, but for this example, "Employee Name" and "Employee
#" is on the worksheet titled Employee.)

Formula used: =vLOOKUP("b2",Employee!a:b,2,FALSE)

"B2" is populated by the drop down and is the Employee Name. Employee
worksheet looks like this:

Employee Name Employee #
Joe Schmoe 001
Bob Smith 002

I have inserted this formula in B3, because that's where I want the Employee
# to populate. However, after inserting the formula, it gives me the dreaded
#n/a response. I've stepped through the formula and I see that it is reading
the name from the drop down properly, so what am I forgetting to check? I
also removed the quotes around the B2...but then I get the #REF!
error...which is worse, I think.

Could it be that my numbers in the employee number column are text? (I need
it to be because some have letters in their ID.) I did change it to see if
it made a difference, but it did not. I am stumped.

Thank you for your time.
J.