Highline Excel 2013 Class Video 20

VLOOKUP, DGET & MATCH For Looking Up Records 7 Examples

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.