Skip to main content

Posts

Showing posts with the label Google Spreadsheets

How To Use GoogleLookup in Google Spreadsheets

Just like Microsoft Xl google Spreadsheets also has a lookup function. XL has the vlookup  The V in VLOOKUP stands for vertical. Use VLOOKUP instead of HLOOKUP when your comparison values are located in a column to the left of the data that you want to find. Google Spreadsheets are becoming more and more popular because it is so easy to use and you can open documents from Gmail directly into Google Spreadsheets.  Here is a brief explanation on using this feature given by the Google Docs Blog .  To use the GoogleLookup function, enter the following formula in the desired spreadsheet cell: =GoogleLookup(“entity” ; “attribute”)  where “entity” represents the name of the entity you want to access and “attribute” is the type of information that you want to retrieve. For example, I want to know the atomic number of gold. In this case, gold is the entity while atomic number is the attribute. In the desired cell, I enter =GoogleLookup(“Gold” , “Atomic Number”). Be sure to include quotation mar...