VLOOKUP, DGET & MATCH For Looking Up Records 7 Examples

Topics: Lookup Formulas, a few Statistics functions, Goal Seek

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