Many thanks, such a speedy reply.
Have a drink on me!

George

*JE McGimpsey* has posted this message:

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