strongman86
Board Regular
- Joined
- Feb 15, 2017
- Messages
- 115
- Office Version
- 2019
- Platform
- Windows
Guys,
Columns A & B are in the same workbook but different tab. Where in the formula I should insert reference to other tab. Thanks.
=$F2<>index($B$2:$B$100,match(mid($E2,3,4)*1,$A$2:$A$100,0))
Columns A & B are in the same workbook but different tab. Where in the formula I should insert reference to other tab. Thanks.
=$F2<>index($B$2:$B$100,match(mid($E2,3,4)*1,$A$2:$A$100,0))