Hi Guys,
Not sure if this is even possible.
I have a list (70k) of vendors with keywords on what they supply. A vendor can have anything from 1 to 400 entry's with a range of products from armoured doors to whipped cream.
Currently this list is in access query as I have to add other data from additional tables (but donst effect the number of rows)
I want to put something within Google docs that allows a user to search for "Whipped cream" and return all instances of that keyword. This will need to be a partial search not an exact search.
I understand I can use the find function however I want to make it as user friendly as possible as the audience is large and of varied skill. So I want a big box that says "search for keywords here" and returns only the matched records.
I have little experience with google sheets/drive etc hence my plea.
If this is not possible I may have access to Power BI. is this something that Power BI can do?
Thanks
Poc
Not sure if this is even possible.
I have a list (70k) of vendors with keywords on what they supply. A vendor can have anything from 1 to 400 entry's with a range of products from armoured doors to whipped cream.
Currently this list is in access query as I have to add other data from additional tables (but donst effect the number of rows)
I want to put something within Google docs that allows a user to search for "Whipped cream" and return all instances of that keyword. This will need to be a partial search not an exact search.
I understand I can use the find function however I want to make it as user friendly as possible as the audience is large and of varied skill. So I want a big box that says "search for keywords here" and returns only the matched records.
I have little experience with google sheets/drive etc hence my plea.
If this is not possible I may have access to Power BI. is this something that Power BI can do?
Thanks
Poc
