Google recently introduced this really cool Lookup Function which allows you to enter in data without having to look it up yourself. A simple example could be the birth date of a famous person which would be easy to find online, but you could do it automatically within the spreadsheet. Really useful when you have a list of people you want to compile data on.

Google does restrict this function to being used 1000 times per spreadsheet. Rightly so in my opinion to reduce load on their servers.

An example query to get the birth date of president Bush:

=googlelookup(“George W Bush”,”date of birth”)