Question

In cell D3 on the Investment Detail worksheet, enter a VLOOKUP function that displays the growth last year for the symbol in cell B3. The growth last year for all investments can be found in Column E on the Investment List worksheet. Your function should look for an exact match to the lookup value. Consider that this function will be copied and pasted into the range D4:D17 when defining the arguments.

Answer 1

Solution:

I have created an excel with two different worksheets. Investment_detail, Investment_List.

Based on the above question from the Investment detail worksheet we have to use the VLOOKUP function that can be referred from the investment_list.

• Click the Cell D3 on the Investment_Detail worksheet.
• Type the below formula on the cell.  

=VLOOKUP(B3,Investment_List!A:E,5,FALSE)

Syntax:

=VLOOKUP(lookup_value,table_array,col_index_num,[range_lookup])

Explanation:

lookup_value - which one we are going to search. In the above formula, we are going to use the B3 cell value (Investment detail sheet) that is we have to search whether the Symbol value is present in investment_list or not.

table_array - It shows which table we have to look the value. Here we have to check the Symbol value in the Investment_List worksheet.

Col_index_num : it define which column should return from the Investment_List worksheet. Here we have to return the Last_Year_Growth that is the column 5 in the Investment_List worksheet.

[range_lookup] : It is optional we have to select approximate_match or exact_match.

True - Approximate Match

False - Exact Match

In the above screenshot cell D3, we use the vlookup value. We have to drag and drop the cell to make it applicable on the below rows.

Now it is applicable in the below 6 rows. In case if you want upto D17 you have drag till the 17th row.