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

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,737
Office Version
  1. 365
Platform
  1. Windows
Hi & welcome to MrExcel.
It looks as though the values Dept Id column are text, but those in the Cost Center column are numbers, is this correct?
 

BJSinger7623

New Member
Joined
Feb 20, 2020
Messages
7
Office Version
  1. 365
  2. 2019
  3. 2010
Platform
  1. Windows
Hi & welcome to MrExcel.
It looks as though the values Dept Id column are text, but those in the Cost Center column are numbers, is this correct?
Maybe that's my issue...they should be the same...numbers.
 

BJSinger7623

New Member
Joined
Feb 20, 2020
Messages
7
Office Version
  1. 365
  2. 2019
  3. 2010
Platform
  1. Windows
This is the formula suggested by my IT Department, but I can't get it to work:
=VLOOKUP(B4,VLOOKUPCC!A2:B51,2,FALSE)
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,737
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

There's nothing wrong with that formula.
If they are a mix of text & numbers try
=VLOOKUP(B4+0,VLOOKUPCC!A2:B51,2,FALSE)
 

BJSinger7623

New Member
Joined
Feb 20, 2020
Messages
7
Office Version
  1. 365
  2. 2019
  3. 2010
Platform
  1. Windows
There's nothing wrong with that formula.
If they are a mix of text & numbers try
=VLOOKUP(B4+0,VLOOKUPCC!A2:B51,2,FALSE)
You are amazing - thank you so much!!! It works!!!
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,737
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

You're welcome & thanks for the feedback
 

BJSinger7623

New Member
Joined
Feb 20, 2020
Messages
7
Office Version
  1. 365
  2. 2019
  3. 2010
Platform
  1. Windows
Question - it worked for 80%. Not sure why some are coming up with the #N/A when that cost center IS on the look-up form.

1582217194781.png
 

Watch MrExcel Video

Forum statistics

Threads
1,128,025
Messages
5,628,196
Members
416,299
Latest member
Kxs00301

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