Find a row of info by using keywords

**rgrohman** · 10-01-2021, 09:41 AM

I have a spreadsheet for all of our preferred vendors that I want to share with our company. What I want to do is put keywords such as doors, windows, glass, store fronts, door hardware in column A and drag the column down so users can't see it. Then I would like them to open the sheet type in a keyword that they are looking for such as store fronts and have excel give them the rows that have information pertaining to the keyword. There may be 5 vendors that can do store fronts. Is this possible? Thank you in advance for any help.

Rob

**JohnTopley** · 10-01-2021, 09:46 AM

Please see yellow banner at top of page on how to attach a workbook.

**rgrohman** · 10-01-2021, 10:07 AM

I think its attached...

**JeteMc** · 10-01-2021, 07:04 PM

If I understand correctly then:
1. Populate a column (M in the attached file) using: =ISNUMBER(SEARCH(B$1,A101))
2. Populate the range that displays the information using: =IF(ROWS($A$2:$A2)>COUNTIFS($M$101:$M$139,TRUE),"",INDEX(B$101:B$139,AGGREGATE(15,6,(ROW($B$101:$B$139)-ROW($B$100))/($M$101:$M$139=TRUE),ROWS($A$2:$A2))))
Note that Conditional formatting is also applied to the range that displays the information. i.e. cells that contain zeros = white font
Let us know if you have any questions.

Find a row of info by using keywords

LinkBack

Thread Tools

Rate This Thread

Display

Find a row of info by using keywords

Re: Find a row of info by using keywords

Re: Find a row of info by using keywords

Re: Find a row of info by using keywords

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Find if a text value contains one of the keywords

Find all keywords

How Do I find keywords and put it into template?

[SOLVED] HDI - Return multiple keywords in a text column based on a set of available keywords

[SOLVED] Cmd to Listbox (Find info in sheet2) copy/paste info to A7 Excel 2007

Search and find info, if correct info found copy into new worksheet

[SOLVED] where do i find a list of macro keywords

Bookmarks

Bookmarks

Posting Permissions