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

#### night_work

##### New Member
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>

### Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.
 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

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

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
ABCDEF
1FuelCustomerShopProduct
2ExpressFuelInjectors
3AcmeFuelInjectors
4TRANSITFuelInjectors
5AreaFuelDS Pumps
6
7
8
Sheet2

Last edited:
I would do this with a simple pivot table

Last edited:

1,203,203
Messages
6,054,099
Members
444,702
Latest member
patrickmg17

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back