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. https://docs.google.com/spreadsheets/d/1t4OCg2rVQxV0pE1dT1xzOrzzkbyGS0KaPtiLFmHu8U8/edit?usp=sharing

Thanks for looking.