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