Subscribe to Our Channel

Thursday, November 3, 2016

how to use google sheets vlookup Auto Populate Spreadsheet Data in Google Sheets and Excel


how to use google sheets vlookup  Auto Populate Spreadsheet Data in Google Sheets and Excel

Utilizing vlookup as a part of Google Spreadsheet is not unique in relation to how you utilize it in Excel or Open Office. The base idea of vlookup and the parameters that it takes continues as before.
how to use google sheets vlookup 
Google Spreadsheet Vlookup Syntax
VLOOKUP (search_key, go, file, [is_sorted])
There are 3 obligatory parameters and 1 discretionary parameter required to finish the vlookup work.
search_key – This is the esteem to hunt down. For our situation we have to hunt down Designation.
Go – The range is only the arrangement of sections that you determine against which the search_key will be gazed upward. The primary section in the range ought to dependably have the search_key all together for the vlookup to work.
Is_sorted – The segment record in the range from which you might want to get an esteem. The record begins from 1.
To use google sheets vlookup  Auto Populate Spreadsheet Data in Google Sheets and Excel

When you have the example information set up simply take after the beneath ventures to finish the vlookup.

STEP-1: In Sheet1, cell D2, press = (equivalent to) and sort vlookup and hit the tab key.

STEP-2: For the search_key parameter select cell C2 in Sheet1 itself and squeeze comma to move to the following parameter.

STEP-3: For the range parameter tap on Sheet2 and select A1 till B7 and after that squeeze comma.

STEP-4: For the record parameter, enter 2 since the Salary segment is the second segment in Sheet2 and squeeze comma.

STEP-5: As for the last parameter, enter FALSE.

Note: You can't enter 0 rather than FALSE as you do it in Excel for the last parameter.

At last to keep away from cell references getting changed, go to range parameter in your vlookup capacity and press F4

Your last recipe ought to look like as demonstrated as follows:

=VLOOKUP(C2,Sheet2!$A$1:$B$7,2,FALSE)
That is it you ought to now observe the Salary populated for the Designation that are scanning for. You can likewise investigate the video demo underneath to see how this being finished.

how to use google sheets vlookup  Auto Populate Spreadsheet Data in Google Sheets and Excel

No comments:

Post a Comment