VLOOKUP in excel

Question

1.       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. Copy the formula to cell E13.

Answer 1

In cell B13, enter the following formula

=VLOOKUP(A11, A5:B7, 2, FALSE)

To copy the formula to cell E13, you can simply drag the fill handle (a small square at the bottom-right corner of the selected cell) over to cell E13. Alternatively, you can copy the formula in cell B13, and then paste it into cell E13. Once copied, the formula in cell E13 will perform the same VLOOKUP operation for the value in A11, but this time, it will reference the range A8:B10 (since the formula was copied to a cell in column E).