strongman86
Board Regular
- Joined
- Feb 15, 2017
- Messages
- 115
- Office Version
- 2019
- Platform
- Windows
Hi lads,
Need formula in cell E1 that loops through Columns A & C and if cell value is identical i.e. AB1234X vs AB1234X then it need to compare corresponding adjscent cell values in column B & D to see if they are matching. If they are matching then it needs to return TRUE if not matching then FALSE.
<tbody>
</tbody>
Regards,
Strongman86
Need formula in cell E1 that loops through Columns A & C and if cell value is identical i.e. AB1234X vs AB1234X then it need to compare corresponding adjscent cell values in column B & D to see if they are matching. If they are matching then it needs to return TRUE if not matching then FALSE.
A | B | C | D | E | |
1 | AB1234X | 2.40 | AD2456Y | 0.24 | FALSE |
2 | AU1336X | 1.20 | AB1234X | 2.40 | TRUE |
3 | AD2456Y | 0.20 | ZN3590Q | 1.54 | TRUE |
4 | TR3456U | 5.50 | AU1336X | 1.20 | TRUE |
5 | ZN3590Q | 1.54 | TR3456U | 5.52 | FALSE |
<tbody>
</tbody>
Regards,
Strongman86