HELP with auto-populate based off of cell lookup please!

BJSinger7623

New Member
Joined
Feb 20, 2020
Messages
7
Office Version
  1. 365
  2. 2019
  3. 2010
Platform
  1. Windows
So in Column A, I need a formula that will auto-populate off of what is in Column B (which will be tied to another sheet). I tried VLOOKUP, COUNTIF, but I'm just not that great with Excel. Can someone help please?

1582215891032.png

So I want the Supervisor initials to auto-populate based on the Dept ID (Cost Center) and I have this sheet set up for the search:
1582215938216.png


Does that make sense and is it possible?

Preferably, the look-up (cost center and team lead) would be in a completely different worksheet, but if they have to be in the same one that is ok too.

Thank you in advance to anyone that can/is willing to help!
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Watch MrExcel Video

Forum statistics

Threads
1,127,441
Messages
5,624,798
Members
416,054
Latest member
Ariel2219

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
Top