Pulling Lists of Data with an Excel Formula

  • Thread starter Thread starter alan.twedt
  • Start date Start date
A

alan.twedt

I am trying to build a worksheet that will look to an identifier and
return a list of line items that match this identifier.

For example, I have two worksheets. One is a data table and the other
is a form that looks to the table. In the table I have a 500 rows of
data and each row has the label of either red or blue. On the form
worksheet, I would like to type the word red and see the set of rows
from the data table worksheet that has that label.

Is this possible?
 
You can't do that with a formula. You can use Data - Filter - AutoFilter
and see the rows. Only the rows that match the criteria will be visible.
To get what you want you need VBA. Post back if you need more. HTH Otto
 
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

VBA - retrieve data on last create named range from previous inserted named range 0
Excel Moving data to sheet2 from sheet1 0
Return value in an table with variable columns and rows 2
Excel Multiple Worksheets - TransferSpreadsheet VBA 0
Excel macro code for copying data to a cell reference which is set byvalues in two separate cells in 3
Excel Highlighting duplicates 0
Scatter plot / Data from matrices? 1
Excel lookup across entire workbook 1

Back
Top