I have a SP list with multiple columns. I would like to set up a worksheet with a drop down via data validation. I want to be able to specify the column I want from the SP list as the drop down list.

This is bound to be possible...right?