I need help with a formula

N

NT

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
 
N

NT6192

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Summing up cells based on names in adjoining cells - I'm new to using functions 2
PLS HELP ME TO SOLVE THIS PROBLEM 4
Work Budget Salary vs Real Time Salary 0
write macro code 0
Total appointments per agent 2
Need Help with a VBA subroutine 0
Mail Merge Help 1
VBA Coding Help for Beginner 0

Top