MegaSack DRAW - This year's winner is user - rgwb
We will be in touch
Help
I have two sheets, one is data sorted in pay number order of different measures of productivity for staff. The other is a list of staff and their manager name, again listed by pay number. However, some staff have moved teams during the reshuffle, so won't appear on the list of staff with a manager assigned.
How do I get Excell to search my column of pay id's and assign the correct manager name from the other sheet?
Must be numpty proof
X
I could tell you. But I'm still at work ****ing around with my own ****ing spreadsheets wondering how much bastard work I'm going to have to do at the bloody weekend.
x
If I understood your question correctly it is a job for vlookup or hlookup depending how your data is structured. Look at Excel help or Google for these formula to get the detail you need.
If sheet1 column A is pay no. Sheet 2 column a is pay no, b is manager name
=vlookup(a1,select area in sheet 2 with values and fix,2,false)