If statement and List

[maximillianrg]

Hello Excel Masters

This is very simple question

• Cells A1:A10 contains content (could bet text or numbers)
• Cell B1 contains content (also text or numbers)
• Cell C1 contains the formula I am looking for which says - If contents of B1 exist in cells A1:A10 return " " else return "foo"

 

[etaf]

=IF(Countif($A$1:$A$10,$B$1)>0,"", "foo")

 

[Peter_SSs]

This is very simple question

It may be but, if the above suggestion is not what you want, you might clarify in relation to the sample below.
Some people would say that the contents of B1 does not exist in A1:A10
Others would say that it does exist (in A4)
Which is it for your circumstance?

24 01 07.xlsm
	A	B
1	dog	cat
2	ran
3	flew
4	scattered
5	horse
6	rat
7	mouse
8	jumped
9	gathered
10	goat
Sample