Excel - COLUMN Function Problem - Expert Solution

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

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc