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