I need to create a form where the user enters one word of a business name (ex. sears) into a cell. In another cell have a formula that will look for that specific word in a column of business names and return the entire content of the cell. These business names can contain several words (ex. Kmart owned by sears). The lookup word (sears) is not always at the end and it may not be just one word.
So, to reiterate, when the user enteres sears in the blank cell, the cell located maybe next to it will have a formula that will look in Column C (the list of business names) and return the cell content of "kmart owned by sears".
Thanks for you help.
Bookmarks