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.

>Solution :

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

=BYROW(B4:B28,LAMBDA(x,IF(ISNUMBER(MATCH(x,G4:G10,0)),"IN","OUT")))