Multi Drop Down Boxes with a final value

Resolved · Medium Priority · Version 2010

Wed 15 Jun 2016, 16:42 Delegate Rich said...

Rich has attended:
No courses

Multi Drop Down Boxes with a final value

Help Please

I have created a multi drop down spreadsheet
First drop down is 8 Options (product type) once selected the next column has a further amount of options (products)

Once selected you manually type in the quantity required on a 3rd column and hand to our warehouse to pick

For stock take id like this spreadsheet to work out values from our price list and multiply by quantity picked.

I have over 100 different products

Is this possible???

Please treat me like i'm 5 as sumif, vlookup etc is blowing my mind

thanks in advance

Rich

Thu 16 Jun 2016, 09:47 Trainer Marius said...

RE: Multi Drop Down Boxes with a final value

Hi Rich,

Thanks for your question. It certainly sounds like Vlookup combined with the drop-downs would be the solution. I shall prepare a spreadsheet with a simple example of how it might work. Are you able to give me your email address so that I can send you the Excel file?

Kind regards
Marius Barnard
Excel Trainer

Thu 16 Jun 2016, 10:45 Delegate Rich said...

RE: Multi Drop Down Boxes with a final value

Thanks

How do i send the email private?
my account does have my email address??
or send me yours and i will reply

Rich

Thu 16 Jun 2016, 10:52 Trainer Marius said...

RE: Multi Drop Down Boxes with a final value

Hi Rich,

Unfortunately I don't have access permissions for delegate information or courses attended. Please could you send an email to marius@stl-training.co.uk, then I'll reply with the solution.

Regards
Marius

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Excel tip:

Creating a range of monthly payments as text

You could use a formula to create a range of payment ie. payment amount for x% to y% rate with fixed terms and principle.

The text that would be "between Xamount and Yamount".

Here is how to do it.

1 Use the PMT function to get your monthly payments figure or whatever frequency of payments that you choose he start range.

See PMT under Excel Help

2. Nest these in the ROUND function to round decimals see ROUND under Excel Help

3. Concatenate this using "&" and concatenate " to " and concatenate "Between ".

4. Concatenate the above to PMT function for the end range

ie.

="Between "&ROUND((PMT1),decimal places)&" and "&ROUND((PMT2),decimal places)