A Named cell to be in a formula for a code

S

stakar

Hi!
I have a named cell -> combo_chk (cell J3)

This combo_chk changes because of FOR..NEXT from code but the style i
always like this : 4,5,12,40,45

I have 5 columns with values in the rows
A B C D E
1 12 40 41 45
5 6 10 11 40

I want to find if the 1 on column A is including in the combo_chk
then
if the 12 on column B is including in the combo_chk e.t.c.
If it is found return '1' otherwise return '0'.

So for the above example i would get

for the first row -> 0 1 1 0 1
for the second row -> 1 0 0 0 1
because the values from the column B,C and E are including in th
combo_ch for the fisrt row and at last the values from the column A an
D are including in the combo_ch for the second row

The formula that i want to use is like this

IF(OR(A1={4,5,12,40,45});1;0))
IF(OR(B1={4,5,12,40,45});1;0))
etc

Then this formula i want to put in a code because i want to call i
when the code is running

I hope you understand
Thanks
Stathi
 
Top