Hello,
I am trying to come up with a formula that will pull out all records from a separate spreadsheet that have certain terms in one and/or two particular columns. Ideally, the end result would be a separate spreadsheet including all records with whatever term in either column.
For example, here's a really, really simplified mockup of my spreadsheet (the actual sheet being several thousand entries long with 50+ columns of criteria):
(A).(B)Name.......(C)Role Title..........(D)Role Description....(E)Location, etc.
1 Robert..........Blue Manager...........Red....................#
2 David...........Red Associate..........Blue...................#
3 Madeline........Red Manager............Red....................#
4 Sophie..........Blue Consultant........Blue...................#
5 Jack............Purple Manager.........Purple.................#
So I would need to pull all the records including Red, for example, in either/both the title column or the description column (and only the title and description columns), and display these records on another sheet. Does this make sense? I'm happy to clarify.
I've tried combining methods for multiple search criteria to no avail.
I apologize if there is some really simple answer I'm not seeing--but any and all help or ideas would be so very very appreciated.
Thank you so much!
I am trying to come up with a formula that will pull out all records from a separate spreadsheet that have certain terms in one and/or two particular columns. Ideally, the end result would be a separate spreadsheet including all records with whatever term in either column.
For example, here's a really, really simplified mockup of my spreadsheet (the actual sheet being several thousand entries long with 50+ columns of criteria):
(A).(B)Name.......(C)Role Title..........(D)Role Description....(E)Location, etc.
1 Robert..........Blue Manager...........Red....................#
2 David...........Red Associate..........Blue...................#
3 Madeline........Red Manager............Red....................#
4 Sophie..........Blue Consultant........Blue...................#
5 Jack............Purple Manager.........Purple.................#
So I would need to pull all the records including Red, for example, in either/both the title column or the description column (and only the title and description columns), and display these records on another sheet. Does this make sense? I'm happy to clarify.
I've tried combining methods for multiple search criteria to no avail.
I apologize if there is some really simple answer I'm not seeing--but any and all help or ideas would be so very very appreciated.
Thank you so much!
