Google Lookup is a function in Google Spreadsheets that allows you to query Google and have the results come in, nice and neat, within a spreadsheet.
If you’ve ever tried to search for specific values or facts on Google and gotten tons of results for new pages, but not for the data itself, you will like this powerful little formula. You must use a Google document to get at it, but it is a small price to pay.
The Lookup function is not perfect, let’s be clear. It can’t find and parse out the web for you. But you can ask it to find the population of US Cities, for example, or a variety of other attributes.
When Google Lookup is not certain if a reply is not the proper one for your access, you will see a dialog box with a huge number of probable results that you are able to select from. Simply choose the cell and select more options: Or choose a dissimilar value.
Presently this function is accessible in English only. Use the GoogleLookup function, insert the below mentioned prescription in the proper spreadsheet block. Syntax of that function is: =GoogleLookup (“entity”; “attribute”) where “entity” signifies the name of the unit that you need to enter, like Kuala Lumpur or oxygen, and “attribute” is the kind of information/data you desire to get back. Important point to be keep in mind is that, in order for the formula to calculate correctly, quotation signs should be used on both sides of the “entity” and the “attribute”.
Here are a couple of samples from the Google help page:
Different attributes apply to different entities. For example:
- Boston has a population.
- Kofi Annan has a place of birth.
- The Mississippi River has an origin.
Here are a couple of examples:
- To insert the number of Internet users in Paraguay: =GoogleLookup(“Paraguay”; “internet users”)
- To insert the Earned Run Average of Roger Clemens: =GoogleLookup(“Roger Clemens”; “earned run average”)
Google itself suggests you test different variables as they are still testing this themselves. But there are loads of possible small business applications here. Again, you have to operate this function, this tool, from within a Google Spreadsheet, but it isn’t that hard to do and puts the results in a nice format. There are some other spreadsheet functions and tools to explore within the Google Docs area. Just head to the Help Section when you are in your account. If you don’t have an account, well…
TJ McCue is the founder of the Sales Rescue Team and a web content guy.