Check off item on dropdown menu if certain text is within adjacent cell.
I have a large dataset I am trying to organize, and I would like a simple way to check off information in a dropdown menu.
When I am entering new data, I can enter the free text and have it automatically check off the relevant drop-downs, and I do not have to spend a long time manually backlogging.
Example:
Specific Information (A, B, C, D)Dropdown (A, B, C, D) Text contains A, CChecked off A, C.
I have a large dataset I am trying to organize, and I would like a simple way to check off information in a dropdown menu. When I am entering new data, I can enter the free text and have it automatically check off the relevant drop-downs, and I do not have to spend a long time manually backlogging. Example: Specific Information (A, B, C, D)Dropdown (A, B, C, D) Text contains A, CChecked off A, C. Read More