Drop down list/window

[triad_cowboy]

Ok kinda hard to explain what i wanting to do here... but i will give it a shot...

I'm creating a bid sheet, to make bidding faster and more accurate
I have several customers from private clients to businesses. I charge each one a little different.
What i need to do is to let say box A2 is have a drop down list that i can choose from
the drop down list would contain a list like
customer A
Customer B
Private and so on...

also let say customer A ... requires me to add 10% to my rates so when I choose Customer A i would need it to auto add the 10% to the hourly rates... and or total bid.

[Melvinrobb]

I'm not sure what your question is: How do you create the dropdown list? how do you add 10% to the hourly rates?
Would you be able to upload a sample workbook with some mock data, showing the structure you have, and what you want to accomplish, giving specific examples?

[MarvinP]

Hi cowboy,

I think you need to use a VLookup table to do this problem. Look at example #2 at http://www.webber.edu/wunker/Excel/FunctionVlookup.htm to see if you can see how this idea might solve your problem.

[triad_cowboy]

both... how do i create a drop down and have it add the 10% to just that one customer

[MarvinP]

Hi,
Find an example of what I was trying to explain and see how VLookup works to give different customers different percent markup charges.

[triad_cowboy]

This is good example of what I need... But I dont need the entire booklet... and need to make changes
to suit my needs


BOX B3...
that the drop down list i need/want
by choosing different options in B3
it changes the dees in the Fees and commission box below

[triad_cowboy]

No Help??