diTii.com Digital News Hub

Sign up with your email address to be the first to know about latest news and more.

I agree to have my personal information transfered to MailChimp (more information)


GoogleLookup function in Google spreadsheets

Have you been frustrated trying to find the populations or capitals of a list of countries? “GoogleLookup function in Google spreadsheets does all the work in a matter of seconds. Using the information collected from Web using Google Search, GoogleLookup function finds the values for straightforward facts about specific things,” explains Google.

To use GoogleLookup function, enter following formula in desired spreadsheet cell: =GoogleLookup(“”entity”; “attribute”) — “entity” represents name of entity you want to access and “attribute” is type of information you want to retrieve. And, to apply formula to a larger list of elements, — just freeze appropriate rows and columns with “$” symbol, which allows dragging formula across the column and down other rows, apply the formula to all other entities, the results will show.

When GoogleLookup isn’t sure if an answer isn’t the best one for your entry, you’ll see a dialog box with a handful of possible answers that you can choose from. Just select the cell and click More Options… to select a different value.

Checkout the video below to see GoogleLookup function in action and don’t forget to give it a try to see what kind of facts you can find:


Share This Story, Choose Your Platform!