Creating drop-down validation menus with reduced ranges?

Hi,

wasn't really sure how to phrase the title, but hopefully now that you're reading you can help me out.

i have a table of tools and their properties which i am using to provide validation lists for a number of other worksheets that record when those tools were last calibrated/tested and when they need to be calibrated/tested next.

many tools require more than one form of testing (electrical and/or calibration), but not all tools require both.

can i create some kind of drop-down menu the looks at the tool master list, but only gives the option of those that require the particular type of testing i'm recording on that particular list? how can i create a drop-down list that is more limited than the range i have selected for it to display?