132k views
5 votes
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.

2 Answers

5 votes

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.

User Sledgeweight
by
8.0k points
4 votes

Answer:

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

User FlashMark
by
7.8k points
Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.