I have created a sample inventory of metals I keep on hand in my shop. I would like to build an estimating spreadsheet that includes drop-down dependent lists (like I've already started). The ultimate goal is to extract the price of each item after I've selected the corresponding drop-downs.
For example:
1- I carry a line of either steel or aluminum (list #1)
2- I carry a line of steel angle, steel flat bar, steel round bar, etc. as well alum. angle, alum. flat bar, alum.round bar, etc. (lists #2 & #3)
3- I carry a line of different sized steel angles, different sized steel flat bars, etc. and different sized alum. angles, different sized alum. flat bars, etc. (Lists #4 & #5)
My drop-down lists work just like I'd like them to but I'm having trouble coming up with the formula to extract the price using the parameters I've selected. I'm thinking some form of VLOOKUP or MATCH but I may be barking up the wrong side of the tree.
I'm also not married to the list setup, so if there is a more efficient way to handle this, I'm open to suggestions.
Thank you kindly!
---Ford
Bookmarks