First, let me say that I have read the previous posts about using the INDIRECT() function in conjunction with the data validation function in excel, however, this does not achieve what I am looking to do.
I have a "database" worksheet whose first two columns (A:B) are categories and types...