I want to name cells A3, A7, A10 and A12 as "Træ". I now how to do this, and in the "define name" box there is a name in the workbook wich says "Træ" and refers to the right cells. But when I in the workbook select "Træ" in the name box it also marks the right cells, but after selected Træ it says A12 in the namebox. I wonder if this is the problem as i can not get it right when i am using the Indirect function in data validation.
I have uploaded my document so you can see what i mean.
What i want is in sheet "data" cell A2 be able to select the main categori "træ", In cell B2 ble able to the undercategories "spærtræ", "skillerumslægter", "Krydsfiner" and "Forskalling". And in cell C2 if ex. "Spærtræ" is selected in C2, only be able to select "47x125", "47x200(4,2m) or "(47x250).
So it is a indirect function in cell B2 and C2. Material Prices.xlsx
Bookmarks