Formula or code?

TGGarmoEX

New Member
Joined
Jun 14, 2019
Messages
12
Platform
  1. MacOS
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.
 

Attachments

  • 450A4B00-3ABB-4E87-B382-F86E55DD236E.jpeg
    450A4B00-3ABB-4E87-B382-F86E55DD236E.jpeg
    159.2 KB · Views: 12
  • 9F606B69-C808-4C88-A4BF-06614C25CD8C_4_5005_c.jpeg
    9F606B69-C808-4C88-A4BF-06614C25CD8C_4_5005_c.jpeg
    63 KB · Views: 12

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

Forum statistics

Threads
1,223,228
Messages
6,170,871
Members
452,363
Latest member
merico17

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top