Please send me code to the following example:
There is a column with dropdown list to select values E.G A1 to A10 from a dropdown list "aaaaaa","bbbbb","cccccc","dddddd","eeeee"
Instead of selecting manually the code must read numeric values from B1 to B10. between 0 to 4.
If B1 has 2, the value of A1 should be "cccccc". The code or function must read values from column B and populate values in Column A accordingly.
Thank You in Advance
There is a column with dropdown list to select values E.G A1 to A10 from a dropdown list "aaaaaa","bbbbb","cccccc","dddddd","eeeee"
Instead of selecting manually the code must read numeric values from B1 to B10. between 0 to 4.
If B1 has 2, the value of A1 should be "cccccc". The code or function must read values from column B and populate values in Column A accordingly.
Thank You in Advance
