Hi guys n gals, I’m struggling and could use a bit of help please. I’m not sure if it can be done through Vlookup() etc, or needs to be a bit of code.
Sheet 1 I have a list of CLIENTS; their GEOGRAPHICAL LOCATION; STAFF ALLOCATED TO THE CLIENT and an empty column where I want the AREA THE STAFF WORK FROM filled.
To do this I want SHEET 1 to look at SHEET 2 and where the 'staff name' are a match, fill the corresponding AREA THE STAFF WORK FROM in column E.
We have a lot of ‘comings and goings’ so the idea here is that it saves me time when it comes to allocating staff to clients.
I hope i’ve explained it okay.
Sheet 1 I have a list of CLIENTS; their GEOGRAPHICAL LOCATION; STAFF ALLOCATED TO THE CLIENT and an empty column where I want the AREA THE STAFF WORK FROM filled.
To do this I want SHEET 1 to look at SHEET 2 and where the 'staff name' are a match, fill the corresponding AREA THE STAFF WORK FROM in column E.
We have a lot of ‘comings and goings’ so the idea here is that it saves me time when it comes to allocating staff to clients.
I hope i’ve explained it okay.