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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Dependent list in excel to create validation 1
List Validation Based on another sheet 5
VLookup using lookup table 1
how do i "link" two sets of named ranges 2
Data Validation to exclude blank cells 6
Indirect function help 2
Help with validation functions 1

Back
Top