I am trying to compare the word in one specific cell to the word in several
other cells in a single column. The purpose is that the cell were the code is
should display a specific word if the comparision is equal, if not it should
display the word in the specific cell you want to compare with the column.

I have managed to do this but in the way I do it I have to write a hell of a
lot of code since it is many cells that the specific cell should be compared
to. This is probably easily solved, or at least it feals like it should be
easily solved if you know the program a bit better. The code I use is:


=IF(OR(I6=B4;I6=B5;I6=B6;I6=B7;I6=B8;I6=B9;I6=B10; I6=B11;I6=B12);B2;I6)


As you see I now compare cell "I6" with cells B4 to B12 why the code isn't
redicolously long but I would like to compare to many more cells and then it
will be. My initial fealing was to write B4:B12 but this gave the error
"#value" which is natural since ":" make a sum but it is something similar I
would like to do, short and simple.

If anybody has a solution to this I would be highly grateful.

thanks
Pontus