How to auto add data based on value in another column

A

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.
 
M

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
 
G

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
Click to expand...
 
M

Max

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

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

Gord Dibben

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

How many is "and so on"?


Gord
 
M

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.
 
Top