Excel - COLUMN Function Problem - Expert Solution

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

I have data validation linking two columns - when you enter a name (only specific listed names allowed) then tab to the next column it is supposed to automatically enter the matching data (doctor name - doctor speciality are the validation lists). Recently it became corrupted for some unknown reason and no longer links, so now you can free type in the speciality column. Any hints?
Solved by O. E. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 10/04/2018 - 09:45
Dear Student. I hope you're doing great today! :-)
User 10/04/2018 - 09:45
Very kind. this is driving me slightly nuts though.
Excelchat Expert 10/04/2018 - 09:45
Do you have data that we can work on?
User 10/04/2018 - 09:45
Unfortunately no, it's confidential stuff
Excelchat Expert 10/04/2018 - 09:46
Oh. I Understand. No problem. :-)
Excelchat Expert 10/04/2018 - 09:46
Can you further describe the problem?
User 10/04/2018 - 09:47
Okay. We have two columns of data / validation lists. They are set up via the Name Manager and usually when you type in a name in the first column (restricted to specific list) it automatically enters the second column information that matches that name.
User 10/04/2018 - 09:47
it stopped working because some clown messed with it, added a name directly to the list or something (no one is confessing)
Excelchat Expert 10/04/2018 - 09:48
Ok, You have 2 columns. Let say A and B.
Excelchat Expert 10/04/2018 - 09:49
Column A, is that column the data entry part.
User 10/04/2018 - 09:50
the two fixed and immutable lists are Doctor names, linked to their speciality. On worksheets when we enter any of those doctors, it should automatically bring their speciality when we tab to the next column
Excelchat Expert 10/04/2018 - 09:50
I mean, you enter the name and in column be supposed to be appear the data that it matches the columnA. Is that right?
User 10/04/2018 - 09:50
sounds right
Excelchat Expert 10/04/2018 - 09:51
All right.
Excelchat Expert 10/04/2018 - 09:51
Now what's the result the column B is giving?
Excelchat Expert 10/04/2018 - 09:51
for example.
Excelchat Expert 10/04/2018 - 09:51
Does it give you ERROR result?
Excelchat Expert 10/04/2018 - 09:51
or blank?
User 10/04/2018 - 09:52
Nothing at all. You enter a doctor name in the first column and tab...nothing happens. You have to manually type and it lets you type ANYTHING, which is also wrong
Excelchat Expert 10/04/2018 - 09:52
ok. I want you to check the cell where the data should appear automatically
User 10/04/2018 - 09:53
comes up with nothing in the boxes (i.e. allow any value, no option to uncheck the blank box etc)
User 10/04/2018 - 09:54
in the data validation boxes i mean
User 10/04/2018 - 09:55
Oh no I have to leave, my shift handover starts now. Ten minutes to go and I am so sorry! If I come back on next shift tomorrow how does one pay for the next session?
Excelchat Expert 10/04/2018 - 09:55
Oh. I hope to hear from you again.
Excelchat Expert 10/04/2018 - 09:55
Please do visit us again. Alrighty... :-)
Excelchat Expert 10/04/2018 - 09:55
For your spreadsheet problems and inquiries always do visit us at https://www.excelchat.co/ We will be more than willing to help you. Have a beautiful day and God bless you!
User 10/04/2018 - 09:56
REALLY wanted to know the answer! Thanks anyway
Excelchat Expert 10/04/2018 - 09:56
My pleasure. Thank you also. God bless you.
User 10/04/2018 - 09:56
thank you :)

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