Question

What output will the look up formula below produce in relation to the following table?

Answer 1

Answer:

The VLookup checks a value inside a table through matching over the 1st column.

Lookup a value in a table by matching on the first column and the matched value is returned from the table.

Explanation:

The formula for the VLOOKUP is

=VLOOKUP (value to be matched in the first column, table from which the value will be looked for, col_index is the column inside the table from where the value is fetched, [range_lookup] is true for the approximate match, and false for exact match)