How to auto add data based on value in another column

[AlanMB]

Hi, I want to automatically add data in a column depending on the value of
data in another column. For example, if column one has a value of 1,3,9 or 12
then a value of 1 is automatically entered in column 2; if column one has a
value of 2,4,7,8 or 11 then a value of 2 is automatically entered in column
2.... and so on. Thanks.

 

[Max]

One way
Assuming data is in A1 down
in B1
=IF(ISNUMBER(MATCH(A1,{1;3;9;12},0)),1,IF(ISNUMBER(MATCH(A1,{2;4;7;8;11},0)),2,""))
Copy down

 

[Gord Dibben]

Max

What about the "and so on"<g>


Gord

One way
Assuming data is in A1 down
in B1:
=IF(ISNUMBER(MATCH(A1,{1;3;9;12},0)),1,IF(ISNUMBER(MATCH(A1,{2;4;7;8;11},0)),2,""))
Copy down

 

[Max]

.. What about the "and so on"<g>

Aha, I missed that, Gord.
Guess I should have said: "Try something like .. "

---

 

[Gord Dibben]

I always have a problem with the "and so on" and "etc."

How many is "and so on"?


Gord

 

[Max]

Agreed, subjective. And that could well form the subject of a new post by
the OP. But as-is, think the OP is quite happy with the response.