How to use VLOOKUP in Google Sheets?

 

Using Vlookup in your Google Sheets document is quite easy. Here are the step by step process to use VLOOKUP in the Google Sheets:

·         Open your Google Sheets document

1.         Now select the Cells where you want Vlookup result to appear
2.          Type Vlookup formula in the selected cell
3.        =VLOOKUP(search_key, range, index, [is_sorted])
4.             Specify the parameters
5.             By putting all the values in the relative parameters, click the Enter button

For better understanding results you have to know about basic formulas,sum,difference,multiplication.,average.and countif we will better guide about these formulas in the individual articles.

There is a simple way to learn countif click Here