I found the websheet
In September I wrote about the websheet, a tool that would allow me to put live Google and web data into a spreadsheet.
Four months later, the best version I’ve found is right here.
The web lookup part needs more functions and it needs to be open so others can add to it, but it’s a great start and it’s free. (hint: try ‘insert function’, hit ‘more’ and choose ‘Googlelookup’.) The help screen explains how it works.