You need named ranges for each table on the dropdown lists sheet:
RECTANGULAR_TUBE ='DROP DOWN LISTS'!$K$2:$K$13
ROUND_TUBE ='DROP DOWN LISTS'!$G$2:$G$27
SQUARE_TUBE ='DROP DOWN LISTS'!$E$2:$E$18
THICKNESS ='DROP DOWN LISTS'!$I$2:$I$7
TubeTypes ='DROP DOWN LISTS'!$M$4:$M$9
on sheet one the data validation formula for description is: =tubetypes
for size it will be:
because you will have to replace the space in the description with an underscore since spaces are not allowed in range names
then for thickness, just =thickness
Bookmarks