Hi
have a look at VLOOKUP. See:
http://www.contextures.com/xlFunctions02.html

--
Regards
Frank Kabel
Frankfurt, Germany

"NT" schrieb im Newsbeitrag
...
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