Look Up String In Range; If present, Set next Cell to '1'

I have a column of code values (can be any # of values from 1 - 300)
If any of 12 specific values are present, I need to set its corresponding cell to the right = 1.

I was thinking to define the range in Column B, then search for each value 1 by 1. With each search, if present, set cell to right = 1. Look for next value until done. I don't think I can look for all 12 in a single 'IF' AND correctly apply the desired values?

Example: If Col B = column of 'codes' and RT1 is one of the 12 values that need to be set to 1, I need the code to search through all possible values in Col B for RT1 and then change the value provided in Column C to '1'.

Col B
AAREQ
SSPEI1
SSPEI2
SSPEI3
RGEAQ
RGTRQ
RT1
RT2
RT3
R1T

[How do I bold my thread title?]

I thought that the better way myself. Col B resides in sheet named 'REGISTER'. The list of constants (which is actually 21, not 12) I placed in the 'SYSTABLES' sheet. That said, this is what I've compiled so far:

Please Login or Register  to view this content.

I don't know if I necessarily need the 'Products' range. I am thinking, within an 'IF' statement, I can identify the range/sheet. Regardless, once the 'IF' statement is established, it needs to Loop through the entire range.

I so apologize for not doing things according to proper rules. This is my second thread. I'm hoping to get better. How does one 'bold' the thread title when initiating the request? TIA.

This is my most current incarnation -

Please Login or Register  to view this content.

The problem with this is it will set the wrong cell to '1'. The setting of 1 will occur in SYSTABLES ws not REGISTER ws.

I'm thinking I must somehow activate the cell located in REGISTER to then set the adjacent cell value to 1? And then re-activate SYSTABLES & StaticVal range?

Help??? Thanks.