I have an ISNUMBER(MATCH()) that is not working in CF but works in cells
Range Table1[Charge Code] is $B$5:$B$78
Range Table2[Code] is $G$5:$G$78
I want to highlight values in Table1 range if they are found in Table2 range
ISNUMBER(MATCH(B5,Table2[Code],0))
Alternative 1:
ISNUMBER(MATCH(Table1["at"[Charge Code]],Table2[Code],0))
Alternative 2:
ISNUMBER(MATCH(B5,$G$5:$G$78,0))
This formatting condition applies to $B$5:$B$78
None of these are working for me. Any help would be appreciated.
Bookmarks