Initializing a value in a cell

[AL]

Hello everyone...

Can someone PLEASE HELP me figure this out... I've created a
"commission schedule" worksheet for real estate agents. All the agents
are on a different commission split. (which means: agent A is on a
fixed commission of $695; agent B is on a 60/40 commission split where
agent B keeps 60% of the deal and company keeps the %40; and finally
agent C is on a 70/30 commission split) I've put the names of the
agents in a drop-down list. When I select an agents name from the list,
how can I make a cell in excel reflect the commission for that agent
only.

For example: if I select agent B from the drop-down list, I want cell
F11 to automatically reflect 60% commission on that cell. Likewise, If
I select agent A from the drop-down list, I want cell F11 to
automatically reflect fixed commission of $695.

PLEASE HELP!!!!!!!!!

 

[Max]

What you need can be achieved either via VLOOKUP or INDEX/MATCH

Try Debra Dalgleish's nice coverage on VLOOKUP or INDEX/MATCH at her:

http://www.contextures.com/xlFunctions02.html
VLOOKUP

http://www.contextures.com/xlFunctions03.html
INDEX/MATCH

There's also some sample workbooks available for d/l & study

 

[AL]

Thank you Max, I will look into it. I really appreciate your help.

AL

 

[Max]

Al, you're welcome !
Thanks for calling back ..