I have a validation box on one page and a table on the other how .

C

chris

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
 
J

Jason Morin

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
 
Top