Use VLOOKUP when you need to find things in a table or a range by row.
VLOOKUP(lookup_value, table_array, col_index_num ,[range_lookup])
In plain language, the VLOOKUP function says =VLOOKUP( what you want to look up, where you want to look for it, the column number containing the value to return, the kind of match you want: FALSE for exact match, TRUE for approximate).
Tip: You can also use XLOOKUP function.
Use VLOOKUP when you need to find things in a table or a range by row.
VLOOKUP(lookup_value, table_array, col_index_num ,[range_lookup])
In plain language, the VLOOKUP function says =VLOOKUP( what you want to look up, where you want to look for it, the column number containing the value to return, the kind of match you want: FALSE for exact match, TRUE for approximate).
Tip: You can also use XLOOKUP function.
Use VLOOKUP when you need to find things in a table or a range by row.
VLOOKUP(lookup_value, table_array, col_index_num ,[range_lookup])
In plain language, the VLOOKUP function says =VLOOKUP( what you want to look up, where you want to look for it, the column number containing the value to return, the kind of match you want: FALSE for exact match, TRUE for approximate).
Tip: You can also use XLOOKUP function.
