I work with Excel 2003

I have a **Teams** (example: G50) and each team there are some **Groups** (example: 70-1, 70-2, etc.).

I want to set a condition that determined the following rule (pic example):

if G50 = 70-1 or 70-2 or 70-3 etc. (up to 5 Groups)

if G51 = 71-1 or 71-2 or 71-3 etc. (up to 5 Groups)

The answer should be: 1-TRUE , 0-FALSE

**examples:**

- G50=70-5 , 1-TRUE (because the GROUP 70-5 belongs to TEAM G50)
- G50=71-1 , 0-FALSE (because the GROUP 71-1 does NOT belongs to TEAM G50)
- G52=70-1 , 0-FALSE (because the TEAM G52 does NOT belongs to GROUP 70-1)