Question

On the "Compiled Information" tab, a VLOOKUP formula has been pre-entered into cell E3. This formula was written correctly, and it uses references to the numbers in cells E1 through G1 to determine the correct index_number parameter. Fill in cells F1 and G1 with the correct index numbers, then copy the formula in cell E3 down to all the rows in columns E, F, and G. What number did you enter into cell G1?

Answer 1

3

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.