Hi,

I require help in the following:

ROW 1 ROW 2 ROW 3
2 1
6 2
8 3
4
5
8

I want a fomula that put a "1" into row one when the value in row 2 is in row 3.

So in the above example there would be a "1" in row one along with number "2" and "8" from row 2.

Hope this makes sense.

Thanks for any help.