1-Vlookup

What is VLOOKUP?
VLOOKUP stands for "Vertical Lookup." It's used to search for a value in the first column of a table and return a corresponding value from another column in the same row.
Where is it used?
It's often used for looking up data, such as prices, names, or any other information in large datasets.
Syntax of VLOOKUP
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
lookup_value: The value you want to search for.
table_array: The range where VLOOKUP will search for the value.
col_index_num: The column number from which to return the value (starting from 1).
range_lookup: TRUE for an approximate match, FALSE for an exact match (usually FALSE is used).