Trying to Included link to my sample file of tables and detailed description of help needed within but apparently I’m not allowed. Please post or PM me your email or receive a link to the worksheet. Happy to compensate once solved if reasonable.
Basics: search a sheet with 150 fixed rows in two separate columns for an OR match to a criteria input in a cell on another sheet. If match is found in either column, return unique identifier in column A of searched sheet for further processing. Desired output is data across 6 specific columns from the corresponding rows where a match was found in searched sheet. Not looking for a single occurrence of a match but rather all matches in all 150 rows of data. Results are to be output into a new table (or similar format for display) with only the output data and no blank lines for cleanliness and readability. Not sure if I am over complicating this or not. Any help is greatly appreciated.
Bookmarks