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


Fronts/Wides:M22s in/on
Center:VP150/VP100 in/on
Hghts,SS,SR:QS8s
Sub:EP500
AVR:Onkyo 3008