Changeable rows in a column?

Question

Visual Basic

Good afternoon! There is one problem! There is a certain column "A" where the parameters are (a, b, c, d, a, b, d, a) and they constantly change places, in some places they repeat, that is, it is completely random. My task is, if A1.value = "a" then insert the value "47" into the column "B1". But the difficulty is that, the values ​​in column "A" are constantly changing or repeating! How can this be implemented? Can you make a loop? But how to insert data from "A2" to "B2" or "A13" to "K13", and the value that should be inserted is also different depending on the cell in column "A"

Answer 1

So far I see two options:
1) B1=IF(A1="a";47;IF(A1="b";"something else";"nothing")
2) create a separate matching list in advance (a - 47 . .. etc.) and use the VLOOKUP() function