Question

the engineering team has a performance data google sheet that shows the machine code and its average daily electricity consumption. the team created a mechanism that displays the consumption in cell e2 based on the machine code entered in d2. however, as shown in the image below, the formula is not working. they ask for your assistance. which is the best way to fix this issue? select only one answer change the formula to vlookup(d2,a2:b6,1). change the formula to vlookup(d2,a2:b6,2). change the formula to vlookup(e2,a2:b6,2).

Explanation:

The VLOOKUP function in Google Sheets has the syntax VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]). Here, we want to look up the machine - code in cell D2 in the range A2:B6 and return the corresponding value from the second column of that range (the consumption value). So, the correct formula should have D2 as the lookup_value, A2:B6 as the table_array, and 2 as the col_index_num.

Answer:

B. Change the formula to VLOOKUP(D2,A2:B6,2).