http://www.excelforum.com/excel-form...selection.html
This post explains what I am wanting to do minus one facet, I have data validated cells spanning 3 columns as opposed to just a single column. I have been playing with the index formula and can't seem to write it correctly. How can I write this formula so that it will look at all three columns? 

{=INDEX($O$1:$O50,SMALL(IF(ISNA(MATCH($O$1:O$50,D$10:D$38,0)),ROW($O$1:$O$50)-ROW($O$1)+1),ROWS(P$1:P1)))}
The range highlighted in red is the range that contains my data validated cells. I would also like for the ranges G10:G38 and J7:J40 to contain the data validation and the list contained therein to reduce with each selection of a cell. Any and all help is appreciated as my little pebble is fried.