One way:

=--(COUNTIF(C9:H9,C12)0)

In article ,
"George Gee" wrote:

Hi all

How do I express this as a formula in Excel:
In P2: If the value in C12 appears in the range C9:H9 then 1 otherwise 0

Hope this makes sense

TIA

George