Highline Excel 2013 Class Video 20

VLOOKUP, DGET & MATCH For Looking Up Records 7 Examples

DESCRIPTION

Topics in this video:
(00:15) VLOOKUP to retrieve whole record change columns manually.
(02:20) VLOOKUP to retrieve whole record column number in cell.
(03:43) VLOOKUP & MATCH to retrieve whole record — more dynamic formula.
(10:24) DGET function to retrieve one record.
(11:42) VLOOKUP and MATCH and Mixed Cell References when you have many records.
(14:24) VLOOKUP to retrieve whole record using ROWS function when you don’t have filed names or don’t want to type column numbers.
ROWS function to increment numbers in a column.
(18:53) VLOOKUP to retrieve whole record using COLUMNS function when you don’t have filed names or don’t want to type column numbers.
COLUMNS function to increment numbers in a row.

WORKBOOKS

Download “Highline Excel 2013 Workbooks” Highline-Excel-2013-Video-Workbooks.zip – Downloaded 114 times – 21 MB




Be the first to comment

Leave a Reply