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 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

MrRoyal MrRoyal · Answer 2 · 2021-10-22T21:55:23+02:00

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:

lookup_value represents the value to look up
cell_range represents the cells to check
column_index represents the column index
[return_value] is an optional entry, and it represents the value that will be returned by the look up function.

From the question, we have:

lookup_value = cell A11
cell_range = cell A5 to B7
column_index = 2
[return_value] = 0

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

Read more about VLOOKUP function at:

https://brainly.com/question/19372969