Sheet 1 – DATA
| School | ItemName |
|---|---|
| blabla sch1 | com.123.abc |
| blabla sch1 | com.456.def |
| blabla sch2 | com.xxx.abc |
| blabla sch2 | com.456.def |
Sheet 2 – CALCs
| ItemName | sch1 | sch2 | sch3 |
|---|---|---|---|
| com.123.abc | TRUE | FALSE | FALSE |
| com.xxx.abc | FALSE | TRUE | FALSE |
| com.456.def | TRUE | TRUE | FALSE |
| com.123.abc | FALSE | FALSE | FALSE |
I need some help calculating the TRUE/FALSE section, I have filled it in manually to show what results I want to achieve.
Essentially, I need an if statement that will be TRUE on sheet 2 if the header and ItemName match on Sheet 1.
