Editable row in the column?


Warning: count(): Parameter must be an array or an object that implements Countable in /home/styllloz/public_html/qa-theme/donut-theme/qa-donut-layer.php on line 274
0 like 0 dislike
10 views
Good day! There is one problem! There is a column "A" there parameters(a, b, C, d, a, b, g, a) and they are constantly changing places, some where repeated, it is random utter. My task, if A1.value = "a" then insert a value of "47" in column "B1". But the difficulty is that the values in column "A" are constantly changing, or repeated! How it can be implemented? Can do some sort of cycle? But how to insert data from "A2" to "B2" or "A13" in the "K13", and the value to be inserted is also different depending on the cells in column "A"
by | 10 views

1 Answer

0 like 0 dislike
So far I see two options:

1) B1=IF(A1="a";47;IF(A1="b";"something else";"nothing")
2) create a separate list in advance of compliance (a - 47 ... etc) and use the function VLOOKUP()
by

Related questions

0 like 0 dislike
2 answers
0 like 0 dislike
2 answers
0 like 0 dislike
2 answers
0 like 0 dislike
2 answers
0 like 0 dislike
2 answers
110,608 questions
257,186 answers
0 comments
35,405 users