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

#### BJSinger7623

##### New Member
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?

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:

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!

### 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
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
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
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

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
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

You're welcome & thanks for the feedback

#### BJSinger7623

##### New Member
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.

#### BJSinger7623

##### New Member
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.

View attachment 7158
10053000103 for DS Evisceration is on the VLOOKUP tab.

#### BJSinger7623

##### New Member
10053000103 for DS Evisceration is on the VLOOKUP tab.
I just answered my own question - sorry!!!!

Replies
6
Views
95
Replies
1
Views
163
Replies
4
Views
301
Replies
6
Views
172
Replies
17
Views
297

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.

### Which adblocker are you using?

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

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