Create new rows in a new sheet based on the selected options in a drop down of a new sheet
Hello,
Source sheet has data like so:
The destination file needs to be like so:
I tried different variations of VLOOKUP but I was not able to make it work any suggestions on how to get this desired result with a formula?
Answers
-
Is there a reason you are doing it this way? It would be much easier if you started with Sheet 2 and consolidated instead of starting with Sheet 1 and parsing.
-
The first sheet is existing with lots of data and is ingrained in our process, we are looking to add a new sheet in this method as we need to Rate each company for each service in each location.
-
A solution to parse the data out the way you want it is going to end up being extremely complex and require (potentially) quite a few helper columns.
Basically we have to parse it out on the source sheet which is where the extra columns come into play and then on the destination sheet some rather complex formulas. We could very quickly run into some limitations possibly before the entire solution is built out.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.2K Get Help
- 360 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives