[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 41
  • Last Modified:

excel 13 multiple selections

I'm working on a bid sheet that has multiple price list associated with it. I've set up separate vlookup drop down lists but , more than one possibility exists within the list. Can I populate a dropdown list that allows a user to select more than one item or do I need a different approach? I have attached a sample of my bid sheet and a data sheet that has more than one selection that could apply (in fact in this case 3 could apply). I'm afraid I have taken an incorrect approach altogether?
Test-Multiple-dropdown.xlsx
0
alohamelinda
Asked:
alohamelinda
  • 4
  • 3
1 Solution
 
FarWestCommented:
could  you provide more clarification about the request,
do you mean you need to select 3 different lines to be shown in the Bid sheet from price list sheet?
0
 
alohamelindaAuthor Commented:
Yes I'm sorry, I would like to return a possibility of more than one line or price to the bid sheet from the price list. Short story is more than one price apply and it looks silly having multiple exact drop downs. Hope you can help.
0
 
FarWestCommented:
Could you please show me a sample of the complete  bed sheet contents. When it has 3 possibilities
You mean you don't need to repeate drop down options to second and third row and you need filtered drop down?
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
alohamelindaAuthor Commented:
That's it exactly. Here's a sample of my decking price sheet. The drains are applicable in just about every circumstance whether it's a paver deck, concrete or say brick. I guess I could create a separate data sheet for the drains, step risers,  etc... How does the filtered dropdown work in this case? Attached is a sample bid sheet for my deck prices.
Deck-Workbook-test.xlsx
0
 
FarWestCommented:
it is better to have category column in your bid sheet to apply filtered list , so when user select the category options in the items will be changed, as I can see you have limited item list, so you can have complete option sheet to all applicable options for each drain  you just select the option and all relevant items will be shown and then you can put 0 or not provided in quantity cell for not included items, this way will help in not forgetting any item :)
let me know if you like to apply category solution, or options based solution
0
 
alohamelindaAuthor Commented:
I'm intrigued. Can you show me a sample of how the category solution might work. Here's an example, I choose:

STD Deck 400 sq ft concrete $0
6" step risers QTY= 20 l. ft.
Paver/Flagstone Accent Bands QTY  = 40 l.ft.
Deco Drain QTY = 40'

How would that look? Sorry my knowledge is so basic.
0
 
FarWestCommented:
sorry for delay
check this as a Category Implementation Sample
Deck-Workbook-test-1-v2.xlsx
0
 
Martin LissRetired ProgrammerCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now