What Is Vlookup ?
Vlookup is a function of Google Sheet that search for a value in a range of column of Google sheet. When you want to search for a value in certain range of Google Sheet and want to return a value in this case vlookup is applicable.You can also use a formula attribute for searching in vlookup.Vlookup is an important wanted function that most likely to be used when you want to interpret your data in Google Sheet .
How to Use Vlookup ?
suppose that you have a Google Sheet given below.
Here is a column name of persons are given in b column age of the person is given and in c column height of the persons in given. Now in d column you have certain names and you have to find out if this is present in column a or not and you have to return respective age. So here the formula you should apply given below
=VLOOKUP(D2,A1:C4,2)
Here d2 is the value for which you have to search and a1:c4 is the range in which value will be searched for and 2 is the index or simply the column number from the first column of range. You can check out this sheet for vlookup test.
Vlookup is a function of Google Sheet that search for a value in a range of column of Google sheet. When you want to search for a value in certain range of Google Sheet and want to return a value in this case vlookup is applicable.You can also use a formula attribute for searching in vlookup.Vlookup is an important wanted function that most likely to be used when you want to interpret your data in Google Sheet .
How to Use Vlookup ?
suppose that you have a Google Sheet given below.
Here is a column name of persons are given in b column age of the person is given and in c column height of the persons in given. Now in d column you have certain names and you have to find out if this is present in column a or not and you have to return respective age. So here the formula you should apply given below
=VLOOKUP(D2,A1:C4,2)
Here d2 is the value for which you have to search and a1:c4 is the range in which value will be searched for and 2 is the index or simply the column number from the first column of range. You can check out this sheet for vlookup test.
Note : index value should be inside your range of search otherwise you will get error (out of bound). If your range is composition of three column then your index should not exist that means we cannot give index value ag 4 or 5.
good worked fine
ReplyDelete