Question

Excel: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.

Answer 1

Answer:

=Vlookup'B13' A11' 7'false

Press enter.

Step-by-step explanation:

Vlookup is a technique in excel which enables users to search for criterion values. It is vertical lookup function in excel which return a value from a different column. The formula for Vlookup function is:

=Vlookup'select cell you want to look up in' select cell you want to lookup from' select column index number' true/false.

where true is approximate match and false is exact match.