I have a quandary and I am unsure how to fix it ... I am creating an asset management spreadsheet that I want to make as "stupid proof" and easy to use as humanly possible. My sub contractors have to be able to do minimal work to add their data, which, when compiled, will easily reach over 10000 rows of information.
I have compiled, in one excel file, much of the basic data that I need to show up in the main spreadsheet to be populated. I have populated some of the rows with simple Data Validation lists, but there are simply far too many options to offer in these lists for all of the data. Scrolling through a hundred items to find the one item in the list you would like will take far too long. I have used vlookups to link several pieces of data but vlookup just isn't cutting it for some of the more complicated functions I want to add. I have tried to use index, match but something I am doing just isn't jiving.
It seems to me that I SHOULD be able to use a combination of either vlookup and choose, index, match (or index, match, match) or some combination of these things to get my spreadsheet to return the information I need automatically, but I can't figure out how on earth I need to combine these equations to make it happen.
SO, long story short, I have my main spreadsheet. I have a Data Validation drop down list where you can choose a certain code. Each code is associated with several attributes which are listed in a table on a different sheet. When someone chooses a particular code from the drop down, I want those attributes from the other sheet to populate into my main spreadsheet automatically.
It's getting to crunch time and I'm supposed to be submitting a draft of this spreadsheet by end of day TOMORROW and I am at my wit's end here.
I'm reasonably certain that what I want to do is possible, but I'm out of time to tinker with it myself ... Please help!!
Bookmarks