Vlookup and Named Ranges in Microsoft Excel

Using the named range instead of selecting the range for the table array makes working in Microsoft Excel more productive and intuitive.
Last time we learnt how to use the Vlookup function which requires the following parameters to extract the right information from our worksheet data range:
=Vlookup(lookup_value,table_array,column_index_num,[range_lookup])
Everytime we used the function we had to select the table array range manually. This can be quite annoying if you have a large range.
We also learnt about named ranges and how to use them properly in the earlier training video. Now we combine the named range feature and the Vlookup function to make our work in MS Excel quicker and easier. The learning video above explains the complete process in detail.
We select the table array data range and give it the name ‘vlookup_data’. As soon as we start writing the Vlookup function and come to the area of the table_array, a drop-down menu shows the named range ‘vlookup_data’ and we can now click on it and the parameter is entered into the Vlookup function for further action.
Now you’ll agree that the process of using a named range along with the Vlookup function makes sense, isn’t it?
Watch the Excel training video:


Further reading:
VLOOKUP Formulas in Microsoft Excel

One thought on “Vlookup and Named Ranges in Microsoft Excel

  1. Shankar

    Hello Sir, I have just started knowing about Macro / VBA potential and started learning, need your help to save my time where I spend a lot of time in sending emails every alternate days,

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *