I need help with a formula
 

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

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

Thanks

I have have looked at vlookup, but was find it hard, but the link you have
given me looks a bit more straight forward

"Frank Kabel" wrote:

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