I have 2 columns B & C
- B includes names
- C includes a dropdown with 2 options – IN & OUT
I have another column – G, that has a list of names and some of the names matches from the main list in column B
Is there a way to automatically change the dropdown value in column C from OUT to IN if the name matches from the list in column G?
Please refer to the sample sheet.
Thanks for looking.
If you wish about formula then could try following formula. See your sheet.