|
Ok... I have till Monday to get this done. I'm working on part of my Excel class's final exam...
I have most of it done, but the last major part of it here is driving me up the wall. I'll attach the file here... it will make a lot more sense if you're looking at it when you read this.
When you click in cells A3 and B3, you get drop down lists of processor brands, amd or intel, and models depending on which brand you selected, same thing with ram, video cards, and mobos. That was all easy enough through data validation / indirect validation lookups...................
Here is what I can't figure out an easy way to do to save my life........:
In cell D4 (and the rest of the price cells for that matter...) it needs to be able to figure out what model is listed in cell B3, find it in the data below, move over one cell, grab it's price, and multiply it times the quantity the user put in cell C3. The only way I can think of to do this is a ton of visual basic that basically says if B3 = this then price = # * quantity.... that's a hell of a lot of raw code to do though give all of the possible choices, can anybody figure out anything easier?
Thanks in advance... you'll be a lifesaver.
|
Threaded Mode