Google Sheet - VLOOKUP Function

Google sheet is a good tool to work with our team and store our data safe.

How do we use the vlookup function in Google sheet.

vlookup function:

The function is used to pull the relevant/corresponding data from master table.

i.e. If you feed the role number of a student; the name and other details of the student can be pulled from student master table.

i.e. if you feed the payment voucher number in a cell, the google sheet will pull the corresponding invoice, PO, amount etc. from the master payment table.

Function syntax:-  =vlookup(searchkey,Range,index,0)

searchkey- the value which will searched
Range- the master table, where the searchkey value will be searched
index- the column number to be displayed / returned by the function.

Important note;
The search key; column should be the first column of the range (table array)
The function returns the first instance value if there are multiple searchkey in the given range

Example:  Click the link to view the example.

https://docs.google.com/spreadsheets/d/1lCGpQGIVkegjG7ME1FArZ393q4qY4oQq4KqWOWQIJaY/edit?usp=sharing
  

No comments:

Post a Comment