You can use VLOOKUP with Google Sheets; it's similar to how the function works in Excel. The VLOOKUP formula can find values in tables on the same sheet or a different sheet, but it can only find ...

Google Spreadsheets is a free, Web-based spreadsheet tool from Google that does a surprisingly good job as a basic number cruncher, and the price is right. Google began accepting sign-ups to ...