Return Row based on value in column

[vdog16]

Hi everyone,

I have a master worksheet with all of my data... about 200 rows worth of items and 10 columns of information about each item.

I am trying to write a formula that returns an entire row of information based on the value in a column.

For instance, if I have a column labeled "Category", I want that entire row of information to be returned if category = "A". If it does not equal "A", then it should do nothing. It will then look at the next row, and the next, and apply the same condition. The goal is to have various worksheets broken out by "Category" with only the rows of information that fall into that "Category".

Furthermore, if only row 7 and row 50 out of 200 rows meet the "A" criteria, I want those two rows to be displayed on the top two rows of the "A" worksheet, not at position 7 and position 50.

Basically, it is equivalent to using the filter function, only I have just one "master" worksheet of data that each of these other worksheets are linked to through these formulas I am trying to write.

I have the feeling that this may be a simple solution, but I am under a deadline and thought someone here may be able to help. Please let me know if you need any more information.

Thanks in advance!

Victor

[vdog16]

please help!

[Ron Coderre]

Since I have concerns that a formulaic approach might result in an overly bloated workbook, I'll recommend this Advanced Filter technique:

http://www.contextures.com/xladvfilter01.html#ExtractWs

Your thoughts?

Regards,
Ron

[Pete_UK]

Check out the VLOOKUP( ) function in Excel Help - this should be able
to do what you ask with a bit of adjustment.

Hope this helps.

Pete

[vdog16]

thanks for both of your help... i actually ended up using pivot tables which did the job. great tips!!!