Search+Return value of the cell to the left

Hello,


I am sure this is an easy fix, but I have been searching everywhere and have yet to find anything.


I have one column with employee names (Column L) and and another column with employee ID numbers (Column M)

I need a macro that when the Employee ID number is searched it returns the Employees Name.

I really dont want a function. I am looking for a macro


Thanks

-Kyle





------L----------------------M

Employee 1 ----------- 1
Employee 2------------ 2
Employee 3 ------------3
Employee 4 ------------4
Employee 5 ----------- 5
Employee 6 ----------- 6
Employee 7-------------7
Employee 8 ----------- 8



End Sub