M
mfrasier31
I want to compare the contents of one cell against the contents of several
cells. I'm currently using {=OR(EXACT(B2,$B$18:$G$27))} where B2 is the cell
I have a value in and B18:G27 is the block of cells I want to compare B2 to.
It's working but it gives me a "TRUE" or "FALSE" result in the cell where the
formula exists. Is there any way to get a different result, specifically a
checkmark or and "X" for true, and nothing if it's false. I tried that and it
told me I had too many arguements. Thanks for any help
cells. I'm currently using {=OR(EXACT(B2,$B$18:$G$27))} where B2 is the cell
I have a value in and B18:G27 is the block of cells I want to compare B2 to.
It's working but it gives me a "TRUE" or "FALSE" result in the cell where the
formula exists. Is there any way to get a different result, specifically a
checkmark or and "X" for true, and nothing if it's false. I tried that and it
told me I had too many arguements. Thanks for any help