I need a formula to check a short list of names and put the appropriate value for that name in. For example, "Supermarket 1" and the value "20%" and "Supermarket 2" with "30%", so each time Column A has "Supermarket A" written in a cell, the appropriate cell in Column B will autofill with the right value instead of having to consult the list and manually enter it each time. This value will then be checked by later formulae
Solved by E. J. in 30 mins