Thanks but it's not working as I want. What I need is for the value in column 2 of sheet 1 assigned to a name to appear in column 3 of sheet 2 whenever that name appears. For example if I have 20 names on sheet one I need the column 3 of sheet two to show the value corresponding to the name I have inputted on sheet 2. Thanks