Forum Discussion
Solved
unable to apply the correct range to the column, "from which the values are accessed" by the VLOOKUP
I am unable to apply the correct range to the column, "from which the values are accessed" by the command/ function. So, what happens is that, there are the following scenarios obeserved, (for t...
Hello learningexcel,
You would simply adjust your Lookup_value and Table_array accordingly. So cell E1 would contain the formula =Vlookup(D1,$A$1:$B$13,2,FALSE).
The 2 in this formula comes from the fact that you want to return the market value of the company that you are looking up. The market value in your Table_array is located in column 2 (the companies are located in column 1). This is where the 2 comes from.
Hopefully this all makes sense to you. Let me know if there are any other questions!
PReagan
The table_array argument of your VLOOKUP consists of 2 columns, which are Column A and Column B. Your col_index_num argument is 2, which means that the result of your formula will come from the 2nd Column, which is Column B.