**Question description:**

*This user has given permission to use the problem statement for this blog.*

## I have 2 sheets. One sheet with the demographics of contractors. eg. Company A, Hispanic, Male. In the second sheet I would like to be able to choose the company from a drop down menu (listing all companies) in column A and have columns B and C automatically populated with Hispanic and Male.

Solved by A. Y. in 34 mins

**This is the chat thread from the real Excelchat help session. It contains no private user information.**

**Excelchat Expert**16/10/2018 - 05:45

Welcome to Excelchat

**User**16/10/2018 - 05:45

Hi thank you.

**Excelchat Expert**16/10/2018 - 05:45

I see that your question is about populating list automatically..

**User**16/10/2018 - 05:46

yes.

**Excelchat Expert**16/10/2018 - 05:46

Can you upload your data in here.? So I can better assist you..

**User**16/10/2018 - 05:46

Ok. it won't be saved after we end chat correct?

**User**16/10/2018 - 05:47

[Uploaded an Excel file]

**Excelchat Expert**16/10/2018 - 05:47

I think you can see the history of this session for later ..

**User**16/10/2018 - 05:48

I'd like when I enter something in Column A of Sheet 2, columns B and C auto populate based on what's in demographics

**Excelchat Expert**16/10/2018 - 05:51

so do you want to populate Prime Contractor SBE (SBE/Non-SBE), Prime Contractor Ethnicity on based on Prime Contractor in column A..

**User**16/10/2018 - 05:52

yep!

**User**16/10/2018 - 05:52

as well as gender

**Excelchat Expert**16/10/2018 - 05:52

for column B .. you have SBE and Non-SBE...

**Excelchat Expert**16/10/2018 - 05:52

do you want to display Y or N ?

**User**16/10/2018 - 05:53

instead of Y it should have been SBE and Non-SBE for N

**Excelchat Expert**16/10/2018 - 05:53

ok..

**Excelchat Expert**16/10/2018 - 05:53

I can help you with that..

**Excelchat Expert**16/10/2018 - 05:53

hold please.. please...

**Excelchat Expert**16/10/2018 - 05:53

it will take a little bit of time..

**User**16/10/2018 - 05:54

no problem, i'm at your mercy lol

**Excelchat Expert**16/10/2018 - 05:54

ok..

**Excelchat Expert**16/10/2018 - 06:00

do you want to autopopulate for sub-contractors also?

**User**16/10/2018 - 06:00

yes

**Excelchat Expert**16/10/2018 - 06:00

one quick question..

**Excelchat Expert**16/10/2018 - 06:00

AAA Automated Door Repair, Inc.

**Excelchat Expert**16/10/2018 - 06:00

E4

**Excelchat Expert**16/10/2018 - 06:00

sub-ctonractor..

**Excelchat Expert**16/10/2018 - 06:01

you have data in the table..

**Excelchat Expert**16/10/2018 - 06:01

but that subcontractor data is not in Demographics..

**User**16/10/2018 - 06:01

yeah that's old data

**Excelchat Expert**16/10/2018 - 06:01

ok..

**Excelchat Expert**16/10/2018 - 06:02

hold on please..

**Excelchat Expert**16/10/2018 - 06:05

it looks like file size increase to 51M..

**Excelchat Expert**16/10/2018 - 06:05

so I can upload it in here..

**Excelchat Expert**16/10/2018 - 06:05

hold on please..

**User**16/10/2018 - 06:08

ok

**Excelchat Expert**16/10/2018 - 06:09

Hold on please.. I am resizing the file..

**Excelchat Expert**16/10/2018 - 06:13

[Uploaded an Excel file]

**Excelchat Expert**16/10/2018 - 06:13

Please check the file..

**Excelchat Expert**16/10/2018 - 06:13

column B to D, F to H will auto be populated based on contractor's name..

**User**16/10/2018 - 06:14

Awesome! Could you tell me how you did it more or less?

**Excelchat Expert**16/10/2018 - 06:14

of cause..

**Excelchat Expert**16/10/2018 - 06:15

Since you have table in the sheet2..

**Excelchat Expert**16/10/2018 - 06:15

I added vlookup formula int the cell...

**Excelchat Expert**16/10/2018 - 06:15

=IFERROR(VLOOKUP([@[Prime Contractor]],Table1,2,0),"")

**Excelchat Expert**16/10/2018 - 06:16

IFERROR is just get rid of error message in case of vlookup can't find data..

**Excelchat Expert**16/10/2018 - 06:16

so main formula is

**Excelchat Expert**16/10/2018 - 06:16

VLOOKUP([@[Prime Contractor]],Table1,2,0)

**Excelchat Expert**16/10/2018 - 06:17

[@[Prime Contractor]] is contractor name

**Excelchat Expert**16/10/2018 - 06:17

Table1.. is Demographics table name..

**Excelchat Expert**16/10/2018 - 06:17

and it is searching 2nd column on Demographics table..

**User**16/10/2018 - 06:18

Did you have to name the table and columns as a separate step?

**Excelchat Expert**16/10/2018 - 06:18

no..

**Excelchat Expert**16/10/2018 - 06:18

table is already there..

**User**16/10/2018 - 06:18

Ok understood! Thank you so much :)

**Excelchat Expert**16/10/2018 - 06:18

no problem..

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*