Listing filtered data from related spreadsheet

  • Thread starter Thread starter Allan
  • Start date Start date
A

Allan

Using a workbook with multiple spreadsheets, one of which
provides extensive source information for other sheets.
An example of the kind of information shown in this sheet
is shown below (assuming this sheet is called SHEET 1) :

SHEET 1

Product Code Description Price

01 First Product 10,000
02 Second Product 15,000
03 Third Product 9,000
04 Fourth Product 26,000
05 Fifth Product 8,500

SHEET 2

In SHEET 2, I would like to generate a list of all
products, listed in Sheet 1, whose Price value is LESS
THAN or EQUAL TO that in a specific cell in sheet 2(eg
cell A2). For example, if cell A2=10,500, my resultant
list should look something like the following :

Product Code Description Price

01 First Product 10,000
03 Third Product 9,000
05 Fifth Product 8,500

Is there a formula or function, or series of formulae or
functions I can use to produce this type of information ?
Any help or advice would be very welcome.
 
A simple way would be to apply an Autofilter to Sheet1.

1. Click a cell inside your data and go to Data > Filter >
AutoFilter.
2. Click on the arrow in the Price column.
3. Choose "Custom".
4. Choose "Less than or equal to" and key in your value to
the right.

If you want to pull it from a cell, you'd have to use
Advanced Filter.

HTH
Jason
Atlanta, GA
 
Back
Top