compare one cell against a range of cells

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
 
S

S.Y.M. Wong-A-Ton

This looks like an Excel question... You may want to try reposting your
question in the Excel newsgroup.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word macro that can call cells out of Excel for a find and replace 0
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Cumulative formula for word table 0
Pasting a cell into bookmarked table from excel vba 1
check first 3 characters of a cell and compare to a table 4
Compare last digit in 5 cells for match 0
Locating differences in text when comparing two cells 10
how to return "summary" of all non-blank cells plus their headers 10

Top