Hello Again,
I am stumbling through what I thought to be a simple LOOKUP function,but am having some trouble with 1 number. I reference 2 columns H - Employee Numbers and I - Employee Name. When employye Number is enrered into B3 Employee's Name comes up in C4. Some numbers start with 0 and I had trouble with these at first, but corrected that with cell formatting, which is CUSTOM-000. The name that is giving trouble is 119 whenever this number is entered it gives me the name in the cell above the correct one.??? My function is =LOOKUP(B3,H6:H39,I6:I39) any help would be great.
THANKS!
I am stumbling through what I thought to be a simple LOOKUP function,but am having some trouble with 1 number. I reference 2 columns H - Employee Numbers and I - Employee Name. When employye Number is enrered into B3 Employee's Name comes up in C4. Some numbers start with 0 and I had trouble with these at first, but corrected that with cell formatting, which is CUSTOM-000. The name that is giving trouble is 119 whenever this number is entered it gives me the name in the cell above the correct one.??? My function is =LOOKUP(B3,H6:H39,I6:I39) any help would be great.
THANKS!