Feb 16 2021 10:52 PM
I did use conditional formatting to check which cells match, however I want to check if both the cells in the column C and U match according to row.
i.e. 100x100 (Beige Khaki) - Polypropelene Fabric (cell C3) - is in row no. 3 and 100x100 (Beige Khaki) - Polypropelene Fabric (cell U3) are in the same row.
Feb 17 2021 01:51 AM
Solution@Somersetinventory Perhaps like this. Enter
=C3=U3
in S3 and copy it all the way down. TRUE means that the cells on the same row in columns C and U match, FALSE means that the don't.
Feb 17 2021 09:19 PM
Thank you so much, I was just unnecessarily complicating things. @Riny_van_Eekelen