Comparing a cell value to a range
Hi again Paladin,
Big woops, sorry. Try this:
=IF(COUNTIF(B1:B5,A1)0,"True","False")
HTH
Regards,
Howard
"PaladinWhite" wrote in message
...
Is there a function to see if the value of a cell appears in a range of
cells?
I want to see if the value of cell A1 appears in any cell B1:B5. In other
words, if my sheet is such:
351 | 219
000 | 183
000 | 281
000 | 351 <-----
000 | 186
... I should get a TRUE return.
|