Kruncher,
Excel seems to be your game.
I've got a spreadsheet that wants to be a relational db, but it can't be and I need some help.
For one section I need about 4 variables picked by the user and then do a look up based on those variables for a description, cost, etc.
Problem is we are a talking thousands of possiblities ( I can handle that part) but I need to have excel do the same lookups in 8 to 10 different sections of the workbook with the possibility of different results on the same dataset. The results also does lookups for additional options based on user input for the 8/10 sections. And the workbook would be to big recreating that data 8/10 times. Not to mention the maintenance
btw, I don't know VB, just excel
Are you willing to look at the file?
Thanks
Jeff
