Trying to automatically change dropdown values in a google sheet, if the data matches from another sheet


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.

>Solution :

If you wish about formula then could try following formula. See your sheet.


Leave a Reply Cancel reply