Multiple Google searches in formula?

%3CLINGO-SUB%20id%3D%22lingo-sub-2243721%22%20slang%3D%22en-US%22%3EMultiple%20Google%20searches%20in%20formula%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2243721%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20create%20a%20market%20research%20form%20where%20one%20can%20enter%20a%20company%20name%20in%20a%20specific%20cell%20and%20search%20additional%20items%20in%20the%20same%20search.%26nbsp%3B%20For%20instance%2C%20say%20I%20want%20to%20do%20some%20research%20on%20IBM.%26nbsp%3B%20And%20the%20info%20I%20need%20search%20on%20is%3A%3C%2FP%3E%3CP%3E'Market%20share'%3C%2FP%3E%3CP%3E'Major%20competitors'%3C%2FP%3E%3CP%3E'Major%20products.'%3C%2FP%3E%3CP%3EEtc.%3C%2FP%3E%3CP%3ESo%2C%20I%20have%20a%20cell%20dedicated%20to%20the%20company%20name%20one%20wishes%20to%20research%2C%20(IBM)%20and%20then%20once%20entered%2C%20it%20goes%20and%20searches%20all%20the%20related%20times%20to%20that%20specific%20company%20in%20a%20different%20row.%20(IBM%20Market%20share)%2C%20IBM%20Major%20competitors)%2C%20(IBM's%20major%20products)%2C%20etc.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20know%20there%20is%20a%20Hyperlink%20function%20where%20you%20can%20insert%20a%20Google%20search%20and%20point%20to%20a%20cell%20to%20search%20on%2C%20but%20I%20would%20like%20to%20have%20the%20search%20start%20with%20name%20cell%20and%20then%20search%20each%20of%20the%20same%20items%20for%20any%20company%20entered.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20possible%3F%20I%20appreciate%20any%20feedback%20and%20assistance.%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3CP%3EGreg%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2243721%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EHyperlinks%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

I want to create a market research form where one can enter a company name in a specific cell and search additional items in the same search.  For instance, say I want to do some research on IBM.  And the info I need search on is:

'Market share'

'Major competitors'

'Major products.'

Etc.

So, I have a cell dedicated to the company name one wishes to research, (IBM) and then once entered, it goes and searches all the related times to that specific company in a different row. (IBM Market share), IBM Major competitors), (IBM's major products), etc.

 

I know there is a Hyperlink function where you can insert a Google search and point to a cell to search on, but I would like to have the search start with name cell and then search each of the same items for any company entered.

 

Is this possible? I appreciate any feedback and assistance.

Thank you!

Greg

1 Reply

@Greg_Abelabelconnec there's no functionality like this in Microsoft Forms.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User