How to create a dropdown checkbox list on each row

Hi,

If anyone could answer this question, that would be great. I've rummaged through a few different Excel forums and threads and tried different solutions, but have not been able to find a way to do this successfully.

I would like to know if there's a way to create a checkbox list in a cell that influences other cells:

For example, I would have column A as "Materials Accepted", and each cell would have a dropdown list with the options "Wood", "Drywall", and "Metal", in checkbox format. Then to the right of that, I would have each of the Materials as actual columns so that column B is "Wood", column C is "Drywall", and column D is "Metal".

The way I would want it to work from there is that whatever options I select from the dropdown, it would then put a TRUE flag in that column. So if I select "Wood" and "Metal" on the dropdown checkbox list, columns B and D would both read TRUE on that particular row.

To give a better idea of what I'm trying to accomplish, here is a screenshot of a mockup I did in paint - http://screencast.com/t/wWP35yR5SguR

Basically on each row, I would select a number of Materials, and the following columns for those Materials would populate TRUE for the ones that I selected on that row. This was just an example, but I would scale this up to around 30 Materials for hundreds of rows/entries.

Thanks for your help.

Does anyone have any advice or suggestions on where to go to get more info on this? Or is this something much more complicated that would be hard or near impossible to do?