What is the VLOOKUP formula used for, and what three arguments does it require?
VLOOKUP is a function that searches for a specified value in a table and returns the corresponding value from another column. It requires three arguments: the lookup_value, the table_array, and the col_Index_num.