- Lookup formula can work vertically in Vlookup.
- When you need to find things in a table or a range by row.
Syntax:
- = VLOOKUP (lookup_value, table_array, col_index_num, [rang_lookup]).
Vlookup function arguments:
- lookup_value: The value to look for in the first column of table.
- table_array: The table from which to retrieve a value.
- col_index_num: The column in the table from which to retrieve a value.
- rang_lookup:
- True = approximate match (default).
- False = exact match.
- Create a lookup table.
- = VLOOKUP (F1, A1:B11, 2, FALSE).
- If the item not in lookup table they default gives "#N/A", if you want change #N/A to another word "No" then we use "IFERROR".
- = IFERROR ((VLOOKUP (F1, A1:B11, 2, FALSE)), "No").
Video:
My notes images:
