LibreOffice Calc - Vlookup & Drop-down lists
Lookup a value in one column then find another value in a column to the right. or use Hlookup to do the same thing with rows. Learn how to create a drop-down list for a cell to eliminate input errors.
Spreadsheet files used in the video are available at http://panopia.com/libreoffice/