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(J2,A2:G23,2,FALSE)

Explanation:

a. In cell J3, begin to enter a formula using the VLOOKUP function.

b. Use the Project ID (cell J2) as the lookup value.

c. Use the Projects table (range A2:G23) as the table_array.

d. Use the Project Name column (column 2) as the col_index_num.

e. Specify an exact match (FALSE) for the range_lookup.

Answer 2

=Vlookup'B13' A11' 7'false

Press enter.

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.