Hi I have a database of about 790 names. Each name has a permanent id, that ID is in Column A in my first worksheet. On my second worksheet it is in column E. They are not in order by this ID, on one they are in order by their name, in the other they are in order by a supervisor's name. On the worksheet with the supervisor's name they have a line item that has a percentage (score). I need to have the first worksheet find the person by their ID number and then put the percentage in a blank space on that worksheet. So this is basically what it looks like
Col ACol B Col C Col D
Perm ID Last Name First Name Percentage (Worksheet 1)
Col A Col B Col C Col D Col E Col F Col G Col H
Bldg they are in, Supervisor Name, Secondary Supervisor, Rank Perm ID, Last Name, First Name, Percentage (Worksheet 2)
Is there a way to get the Percentage column on worksheet one, to populate with the Percentage Column on Worksheet 2 once the Perm ID's are matched?
I tried doing Index and Match but just couldn't make the formula work. Thanks
Joan