SleightOfHand
New Member
- Joined
- Jun 19, 2020
- Messages
- 17
- Office Version
- 365
- Platform
- Windows
Book1 | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | |||
1 | Station 1 | Station 1 | Station 2 | Station A | Station B | Station C | ||||||||
2 | Station 2 | |||||||||||||
3 | Station 3 | |||||||||||||
4 | Station 4 | |||||||||||||
5 | Station 5 | 1 | ||||||||||||
6 | Station 6 | |||||||||||||
7 | Station 7 | |||||||||||||
8 | Station 8 | |||||||||||||
9 | ||||||||||||||
10 | ||||||||||||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
D5 | D5 | =IF(SUMPRODUCT(--(A1:A8=E1:I1))>0,1,0) |
I've used a formula to determine whether the stations from I1 are matched in in any case with the column A1:A7. But this just tells me that these exist; how, for a longer list, would I be able to tell WHAT the actual values that match would be?