# Excel - COLUMN Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I have 2 columns one of them with a dropdown list of 20 and the other one with 2 options only. I want that when Comment A and B are chosen in the first column then the secon column populate "X" STRAIGHT AWAY. HOW DO i DO IT?
Solved by I. D. in 10 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 08/08/2018 - 02:26
Hello, I understand that you want to show X to the second column only if Comment A or Comment B is selected in the first column, right?
User 08/08/2018 - 02:26
yes
Excelchat Expert 08/08/2018 - 02:26
Does your second column have a formula or a manually inputted value?
User 08/08/2018 - 02:27
I want to have another scroll down list
Excelchat Expert 08/08/2018 - 02:27
The reason I asked is because what you need will require a formula so the second column cannot have an existing value.
User 08/08/2018 - 02:28
I am creating the 2 colums from scrach
Excelchat Expert 08/08/2018 - 02:28
Do you see the sheet to the right?
User 08/08/2018 - 02:28
so we can add whatever you think it will work
User 08/08/2018 - 02:28
no
User 08/08/2018 - 02:29
I am at work so my access is denied
Excelchat Expert 08/08/2018 - 02:29
I see. Let me prepare the formula. I'm assuming that your first column will be column A and the second column will be column B.
User 08/08/2018 - 02:29
for example
User 08/08/2018 - 02:29
yes
Excelchat Expert 08/08/2018 - 02:29
Place this formula in B2.
Excelchat Expert 08/08/2018 - 02:29
=if(or(A2="Comment A",A2="Comment B"),"X","")
Excelchat Expert 08/08/2018 - 02:30
Then try to type something in A2. If the value in A2 is either Comment A or Comment B then it will return with an X
User 08/08/2018 - 02:30
done
Excelchat Expert 08/08/2018 - 02:30
Before we proceed, this is a reminder that our policy is 1 question per session so for this session we'll be resolving this particular question. We also currently do not support VBA/Macro solutions.
User 08/08/2018 - 02:30
ok
Excelchat Expert 08/08/2018 - 02:31
Try typing something in A2 or if you already have the data validation drop down list, select something.
Excelchat Expert 08/08/2018 - 02:31
The formula I gave you will only result to X if the value of A2 is either Comment A or Comment B.
User 08/08/2018 - 02:32
ok I got it
User 08/08/2018 - 02:32
sO i WILL NEED A FORMULA
User 08/08/2018 - 02:32
THERE IS NO OTHER WAY RIGHT?
Excelchat Expert 08/08/2018 - 02:33
For something to be automatic, it will either be a formula or VBA/Macro code which we currently do not support.
User 08/08/2018 - 02:33
ok
User 08/08/2018 - 02:33
thanks so much
Excelchat Expert 08/08/2018 - 02:33
You are welcome. Glad to have helped!
Excelchat Expert 08/08/2018 - 02:33
Alright, if you have no other questions regarding the original concern, I'd appreciate a 5-star rating and your feedback if you think I deserve it.
Excelchat Expert 08/08/2018 - 02:34
I'll be giving you high ratings as well so the other experts will know that you are a good client and should be taken care of.
Excelchat Expert 08/08/2018 - 02:34
Please do not forget to click the End Session button otherwise I'll be stuck here until the timer expires and be unable to help others. Thank you.
User 08/08/2018 - 02:34
once I end the sesion I can rate u right?
Excelchat Expert 08/08/2018 - 02:34
Yes. :)
User 08/08/2018 - 02:35
and if I have any other question I need to open a new chat right?
Excelchat Expert 08/08/2018 - 02:35
That's right. We have a lot of experts available so just ask your questions and the right expert will be assigned to you.
User 08/08/2018 - 02:35
brilliant
User 08/08/2018 - 02:35
have a nice day

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.