**Question description:**

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

I need a formula that will allow me to automatically put something in one column based on what is in another column on a seperate sheet

Solved by B. S. in 39 mins

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

Excelchat Expert
03/10/2018 - 11:25

Hi

User
03/10/2018 - 11:25

Hi there

Excelchat Expert
03/10/2018 - 11:25

how are you doing?

User
03/10/2018 - 11:26

I have a list of cities in one column (column h)

Excelchat Expert
03/10/2018 - 11:26

I understand you need a formula to update a column based on the value in another column

User
03/10/2018 - 11:26

i will put it in the spreasheet so you can see what I am, talking about

Excelchat Expert
03/10/2018 - 11:26

can you share me an excel file your working on

Excelchat Expert
03/10/2018 - 11:26

Sure that would be niec

User
03/10/2018 - 11:27

ok

User
03/10/2018 - 11:28

I have various citites in column H with no corresponging counties in column j

Excelchat Expert
03/10/2018 - 11:28

and details are in Sheet2 for each city and county

User
03/10/2018 - 11:28

I would like a forumla to automatically put in the county based on the information provided in sheet 2

Excelchat Expert
03/10/2018 - 11:28

ok got it give me few min to update a formula

User
03/10/2018 - 11:29

ok thanks

User
03/10/2018 - 11:29

so for woodland hills the formula would automatically put in Los Angeles County based on the information provided in sheet 2

Excelchat Expert
03/10/2018 - 11:30

and Los Angeles County for Torrance right

Excelchat Expert
03/10/2018 - 11:34

I have entered a formula in Column J can you verify

Excelchat Expert
03/10/2018 - 11:35

It is an index/match formula where the match function searches for the county in column b of sheet 2 and returns the row number where it wa found then index will return the corresponding rows column A value

Excelchat Expert
03/10/2018 - 11:37

you there

Excelchat Expert
03/10/2018 - 11:38

Do you need any further clarifications on the formula?

Excelchat Expert
03/10/2018 - 11:38

Hello

User
03/10/2018 - 11:42

yeah sorry I am trying the formula

Excelchat Expert
03/10/2018 - 11:42

ok did it work in your sheet?

Excelchat Expert
03/10/2018 - 11:45

let me know if your seeing any errors or are unable to get the formula working

User
03/10/2018 - 11:48

sorry I was having difficulty because the sheets were named differet

Excelchat Expert
03/10/2018 - 11:49

no issues what are the sheet names.. do you mind sharing the actually excel?

User
03/10/2018 - 11:49

I renamed the sheet names in the shared doc to the same names

Excelchat Expert
03/10/2018 - 11:50

see the formulas changed

User
03/10/2018 - 11:51

yeah but it is still not working in my excel document

User
03/10/2018 - 11:51

can I attach it?

Excelchat Expert
03/10/2018 - 11:51

sure

Excelchat Expert
03/10/2018 - 11:51

use the paper clip symbol here

User
03/10/2018 - 11:53

The columns are on the retailer licenses tab

[Uploaded an Excel file]

Excelchat Expert
03/10/2018 - 11:53

let me take a look

User
03/10/2018 - 11:54

ok thanks

Excelchat Expert
04/10/2018 - 12:00

the problem is with your data.. you have enter character when the county has 2 words

Excelchat Expert
04/10/2018 - 12:04

Crowslanding,DSRT HOT SPGS,VALLEY VLG

Excelchat Expert
04/10/2018 - 12:05

will send

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