In cell B13, create a formula using the VLOOKUP function that looks up the value from cell A11 in the range A5:B7, returns the value in column 2, and specifies an exact match.

The VLOOKUP function is used to look up a value in a particular column.

The VLOOKUP formula to enter in cell B13 is: VLOOKUP(A11,A5:B7,2,0)

The syntax of a VLOOKUP function is:

VLOOKUP(lookup_value, cell_range, column_index, [return_value])

Where:

From the question, we have:

So, the VLOOKUP function would be: VLOOKUP(A11,A5:B7,2,0)

Read more about VLOOKUP function at:

link

VLOOKUP(A11,A5:B7,2,0)  is the correct answer to this question.

Explanation:

The VLOOKUP method contains a vertical lookup by scouring for worth in a table's first section and trying to return the significance in the throughout the situation within the same row. The VLOOKUP excel is a built-in function classified as a Lookup / see as.

According to the question:-

The formulation needed to enter is = VLOOKUP(A11, A5: B7,2,0)

The first "A11" here is the cell from which value is retrieved

The second "A5: B7" input is the range for the table where you need to lookup. 2 Is the number of the column from which the value is taken and 0 indicates the exact math

answer; (& & );