Hello Chris -
Here is a link to a video tutorial that I created on this topic. I created this in response to a viewer who asked me the same question that you posed.
I hope that this helps.
Danny Rocks
www.thecompanyrocks.com/excels
http://www.thecompanyrocks.com/excels/ms-excel-training/data-lists/use-indirect-function-to-connect-2-pick-from-lists-in-excel/