Hi htere, i’d like to know iwhat is a practical use of a formula that allows, when I select a voice from a list, to insert a value in another cell.
Example: column with a list (fruits, veggies, meat, fish), let’s say a2,a3,a4,a5.
Another column wtih 1, 2, 3, 4. let’s say b2,b3,b4,b5.
I’d like a formula that, whenever in the cell D14 I write “fruit”, in the cell E14 displays the value 1.
Thank you
