How to use a formula to return a table of sort specific data

[night_work]

Where I work, we have several logs for a variety of different quality related subjects, such as audits, sample requests, vendor qualifications, etc... I am attempting to build dashboards for the production departments and want to link a section of the dashboard to each list, extract information based on department and display it on the dashboard. I have been able to use arrays to get the information to display, but not on consecutive lines.

In this example, from another workbook, I want to search the Shop column for "Fuel" and display the Customer, Part # and Product.

Any help would be greatly appreciated!

Date Ordered	Customer	Shop	New Customer?	Part #	Product
4/11/2013	Express	Fuel	YES	4902921PX	Injectors
4/11/2013	Express	Turbo	YES	170-070-0038	Turbo
4/11/2013	Express	Turbo	YES	170-032-0041	Turbo
3/27/2013	Acme	Fuel	No	636978	Injectors
3/25/2013	TRANSIT	Fuel	NO	637045	Injectors
2/20/2013	Area	Fuel	No	S5521D	DS Pumps

<colgroup><col><col span="2"><col><col><col></colgroup><tbody>
</tbody>

 

[jamtay317]

Fuel
Turbo

<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>

I would use =Choose(match(... not sure what your ranges are

 

[night_work]

Would this be able to return results in consecutive rows? For example on the fuel dashboard, I would only want the information associated with the Fuel lines to display:

Express 4902921PX Injectors
Acme 63697 Injectors
Transit 637045 Injectors
Area 555121 DS Pumps

 

[Robert Mika]

Would this be able to return results in consecutive rows? For example on the fuel dashboard, I would only want the information associated with the Fuel lines to display:

Express 4902921PX Injectors
Acme 63697 Injectors
Transit 637045 Injectors
Area 555121 DS Pumps

Sheet1

*	A	B	C	D	E	F
1	Date Ordered	Customer	Shop	New Customer?	Part #	Product
2	04/11/2013	Express	Fuel	YES	4902921PX	Injectors
3	04/11/2013	Express	Turbo	YES	170-070-0038	Turbo
4	04/11/2013	Express	Turbo	YES	170-032-0041	Turbo
5	3/27/2013	Acme	Fuel	No	636978	Injectors
6	3/25/2013	TRANSIT	Fuel	NO	637045	Injectors
7	2/20/2013	Area	Fuel	No	S5521D	DS Pumps

Down and accross:

Excel Workbook
	A	B	C	D	E	F
1		Fuel		Customer	Shop	Product
2				Express	Fuel	Injectors
3				Acme	Fuel	Injectors
4				TRANSIT	Fuel	Injectors
5				Area	Fuel	DS Pumps
6
7
8
Sheet2

 

[danzon]

I would do this with a simple pivot table