I have 2 sheets on one a signal list with a validation list above :
on the second sheet I have a table with various headings.
What I am trying to do is when you select one of the names from the
validation box it returns the list of values below that specific column
heading on the second sheet.
Note I have 15 column headings on the second sheet, and the below each one
is 180 rows of data

Let's assume your second sheet is called "Sheet2", and
headers run from A1 to O1 with 180 rows of data below.
Your validation list is in A1 of the first sheet. In A2
put:

=OFFSET(Sheet2!$A$1,,MATCH($A$1,Sheet2!$1:$1,0)-1,181)

and copy down to A181.

HTH
Jason
Atlanta, GA

-----Original Message-----
I have 2 sheets on one a signal list with a validation
list above :
on the second sheet I have a table with various headings.
What I am trying to do is when you select one of the
names from the
validation box it returns the list of values below that
specific column
heading on the second sheet.
Note I have 15 column headings on the second sheet, and
the below each one
is 180 rows of data

.