Hi all
I have very basic knowledge of excel, but am able to cobble formulas to get it to do what is required.
I was tasked with putting together a costs calculator for my sales team, so they could give customers an on site budget estimate for roller blinds based on dimensions.
What I have devised, is a list of materials available, and in that line they are able to select available dimensions (drop & width) which then displays the correct cost value from a table that particular material relates to.
I have managed to get a match formula to work, and everyone is extremely impressed with how it works. Unfortunately, they are too impressed and now want me to adapt the cost sheet so instead of having separate lines for each material, they can select the material from a drop down menu, which will then fetch the values data from the correct table. This is so they can have multiple lines of the same material or mix and match quantities one a single cost sheet.
I have looked and looked, but cannot figure out how to get the value from the initial drop down list to select the data from the correct table.
Is this actually possible at all, and if so, could someone point me in the right direction regarding formulas etc.
many thanks in advance.
Maggie - getting older by the minute!
Bookmarks