Business Options/Pricing & Markup

[hidde51]

I was going to fallow up on my last post but im really new to excel and this forum world and JBeaucaire suggested that i open a new thread, so here i am doing so at the advice of him. The message below is specific to him to reply to but for anyone else that might want to help me with this set of formulas to resolve my worksheet headache and lack of skills in excel. Please feel free to have a look at the worksheet i posted and the comments in each color coded cell.
------------------
hay there JBeaucaire,
I was hopping i might get a reply from you.. this is a lot like the other sheet you helped me on. I really appreciate your help i really am pretty lost in this world of excel.
Instead of posting bit by bit and hopping to get helped through bit by bit would you mind looking at this sheet here and it has explanation notes in all the cells and maybe do like you did on the my last post.. where you showed me the formula and what cell to put it in? That helped me out substantially to understand more whats is going on.
I would GREATLY appreciate it and you would save my behind in more ways then you can imagine.. kinda in over my head here i think..

Thanks to all that pitch there input in .. i hope I'm no nuisance to this forum i REALLY am trying to learn this stuff...

Charles

[JBeaucaire]

I reformatted your reference table into a standard two-dimensional layout so you don't have to search all over for the values, it's all in the same table.

The formulas and named ranges have been simplified down to suit.

[hidde51]

again i see why your title is the form guru.. that's AMAZING... probably a simple task for you to do? But you saved me HOURS and hours of headache and frustration trying to figure this out... I am VERY great full for your assistance..
Thank you so much ...
Charles

[JBeaucaire]

My pleasure. West coast power!

[hidde51]

True that... :-)
I have one more set of products in my spreadsheet but I'm going to give it my best effort at what i have learned thus far. Without looking a gift horse in the mouth (not that your a horse lol) after i give it my best shot would you be willing to take a look at the 3rd and what i hope is the final batch for quite some time? lol
Again i really appreciate the help.
Charles

[JBeaucaire]

Sure, of course. Post it up here or in a new thread, Private Message me with the link to draw my attention to a new thread.

[hidde51]

Ok so this one has more data to it and the cover options seem a little more tricky because there is multiple cover options in the 4 groups(price ranges)
You solve this one and thats all i have left on this project..
In advance thanks again and MUCH appreciation.. i think out of all this im starting to grasp the validation pull downs more as for HOW your referencing the appropriate price and markup to get the costs and prices.. I'm Baffled
Think some excel classes are in store for me soon.
Look forward to seeing the results..
Charles

[JBeaucaire]

Here you go. Had to introduce some INDIRECT() + named ranges to get all this to work properly.

Had a real fun time on Cover choices. They won't even show a drop down list unless you get down to size 8x12.

[hidde51]

That is truly amazing.....
Again i am in your debt for helping me with this..
Does this come easy to you?
WOW!
Thanks yet again.