I have a number of agents who all get different commission rates %. In my
spreadsheet i have a column which has a validation list in. What i want is
when i select one of the agents it auto populates another column/cell with
their correct commission rate %.
i.e. If agent 1 gets 20% when i select agent 1 name in say A1 then i want B1
to show 20% without having to type it. In total i have approx 15 agents with
about 4 different % rates.

Can anyway help, i'm very new to these types of formula's