Excel Tips - Tip 12 (Using Vlookup)

Hello,

Hope my excel tips are helping you out.

Here is the Twelfth tip for you. Hope this help you.

Using “VLOOKUP” Formulae is very easy and effective and it is used very frequently in every industry.

Steps to use it:

1. Use =Lookup( in the cell where you want the desired outcome.

2. Select the range of that column against which you want the desired outcome. After selecting the column, press comma (,) [As shown in my table, selected the “Name” column]

3. Now select the table from where you want to pick the desired outcome. After selecting the column, press comma (,)[As shown in my table, selected from the “Actual Data” table]

4. Count the number of columns in between the desired outcome and type the same. [As shown in my “Actual Data” table, there are 4 columns in between “Name” and “English”]. After that, press comma (,)

5. Now use “F4” to freeze the formulae [As shown in table] , [the $ sign means that the formulae is freeze]

6. Now you can copy and paste the said formulae to maximum upto your desired need.

If any of your friends is also interested for the said excel Tips, then asked them to fill the form by clicking on the below mentioned link:

https://docs.google.com/forms/d/12T8v5XY0XlF9IhuCZPQpydd8hjCtrW7hZs9_GiOffIw/viewform?c=0&w=1

If you have something that you want to share with the group, please write to excelms.tips@gmail.com

Please do share your valuable feedback. Keep Sharing.

Thanks & Regards,

CA Mohit Bansal

Excel enthusiast

+91-9045773456