Hi Phil
In cell AA1
=AND(A1="phil",B1="Tony")+AND(A1="Tony",B1="Phil")*1

--
Regards

Roger Govier


"Phil" <someone@home.sometimes.uk> wrote in message
news:o5MHe.81329$G8.58682@text.news.blueyonder.co.uk...
>I am trying to find a formula that looks at a range of cells, a2:b11, and
>if
> a cell in the range has a value Phil and its adjacent cell in the other
> column
> has a value Tony then AA1=1, if no adjacent cells match the criteria AA1
> =0. The names can be in either column.
>
> For instance...
>
> A B
> Phil Tony would give AA1 value 1
> Tony Phil would also give AA1 value 1
> xxx yyy would give AA1 value 0
>
> Thanks
>
>
>
>
>