G
Guest
I'm trying to automatically enter data into multiple cells based on one cells
data.
For instance if a cell in column A = 1 then the adjacent cells in columns B,
C and D will all have specific values which will be true for a value of 1 in
column A.
If the value in the cell in column A = 2 then the adjacent cells in columns
B, C and D will have another set of specific values which will be true for a
value of 2 in column A and so on.
I think lookup tables is possibly the answer but the help isn't much good
and I am struggling!
data.
For instance if a cell in column A = 1 then the adjacent cells in columns B,
C and D will all have specific values which will be true for a value of 1 in
column A.
If the value in the cell in column A = 2 then the adjacent cells in columns
B, C and D will have another set of specific values which will be true for a
value of 2 in column A and so on.
I think lookup tables is possibly the answer but the help isn't much good
and I am struggling!