Hello,
I have recieved much help from this forum already and my spread sheet is just about perfect, in my opinion,
There is just one problem, I added some columns to my reference table "Price Table" and now the drop down menu on my "cabinets detail" sheet is not working.
So just to clarify, On the "Cabinets Detail" sheet when an item number is entered then a description comes up and when a color is entered a price should appear but some of the colors return a "N/A" value in the price cells.
All valid item numbers can be found on the sheet "Price Table"
Can someone please help
I have attached the file here
Thank You
Bookmarks