extract data from list using index

[Kerrold]

Hi

I have a data dump and want to show all data that meets x criteria.

There is a drop down box a the top of the sheet where a date can be selected, once selected i want formulas underneath to pull back all entries relating to that criteria from the database extract which is in a separate sheet within the workbook. I have tried using index and I'm just getting myself in a muddle and have been at this for ages now...

Description - If date selected in sheet 1 = 15/4/13 i want to populate all matching entries in a table below using the data from sheet 2 - referencing the column with the date in (column d) and then bring back the name of that person (column a), plus the surname (column B) and then the outcome (column c). there will be more than one entry (row) matching the criteria so need to pull them all across

Hope this makes sense and you can help!

Thanking you in advance, Kerry

 

[Akashwani]

Hi Kerry,

Do you mean something like this?...

Sample Data and Example Results...

Excel Workbook
	A	B	C	D	E	F	G	H
1	Dates	Data1	Data2		Date	Data1	Data2
2	01/04/2013	Bill	Smith		01/04/2013	Bill	Smith
3	02/04/2013	Bob	Smith			Ben	Smith
4	01/04/2013	Ben	Smith			Bill	Jones
5	04/04/2013	Bud	Smith			Bud	Jones
6	01/04/2013	Bill	Jones			Bob	Brown
7	06/04/2013	Bob	Jones
8	07/04/2013	Ben	Jones
9	01/04/2013	Bud	Jones
10	09/04/2013	Bill	Green
11	10/04/2013	Bob	Green
12	11/04/2013	Ben	Green
13	12/04/2013	Bud	Green
14	13/04/2013	Bill	Brown
15	01/04/2013	Bob	Brown
16	15/04/2013	Ben	Brown
17	16/04/2013	Bud	Brown
18
Sheet1

The formula in F2 needs to be entered with ctrl shift enter NOT just enter, it can then be copied across and down.
You will obviosuly need to change the cell references to suit your layout

I hope this helps.

Ak

 

[Kerrold]

Excellent! Thank you for your help

 

[Akashwani]

Hi,

I'm pleased it works for you and thanks for the feedback.

Ak