Document Matrix

[spr1nger]

I have a list of documents in an Excel Spreadsheet (a matrix per se), listing all documents with their #'s, document titles, what departments each belong to, & revision date. On a 2nd Tab, I'd like to return (link if anything changes on main tab) all documents that belong to a specific department. The way I set up the spreadsheet is with column headings for doc #, title, rev date, then the subsequent columns are each department. The rows are the various documents & I placed an "X" in the column of the department it pertains to. What formula can I use on the 2nd tab to return the list of a specific department?

 

[Fluff]

Can you please post the formula, so that I don't have to type the whole thing out.

 

[spr1nger]

Can you please post the formula, so that I don't have to type the whole thing out.

yes, i'm sorry
=FILTER('Doc Matrix'!A2:S195,INDEX('Doc Matrix'!A2:S195,,MATCH("Purchasing",'Doc Matrix'!M2:M195,0))="X")

 

[Fluff]

Thanks for that, how about

=FILTER('Doc Matrix'!B2:B200,INDEX('Doc Matrix'!J2:N200,,MATCH("Purchasing",'Doc Matrix'!J1:N1,0))="X")

 

[spr1nger]

Thanks for that, how about

=FILTER('Doc Matrix'!B2:B200,INDEX('Doc Matrix'!J2:N200,,MATCH("Purchasing",'Doc Matrix'!J1:N1,0))="X")

That's it!!! Thank you so, so much & thank you for being patient with me! You're a genius ?

 

[Fluff]

You're welcome & thanks for the feedback.

 

[spr1nger]

I'm sorry to bug you again, but can you tell me the formula to use in conditional formatting, if i want to highlight cells A2:E2, if E2 has an "O" in it?

SC DOCUMENT Matrix.xlsx
	E
2	O
Purchasing

Cell Formulas
Range	Formula
E2	E2	=VLOOKUP(B2,'Doc Matrix'!B2:R195,17,FALSE)

 

[Fluff]

As this is a totally different question, it needs a new thread. Thanks