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.
