How can you define the "VLOOKUP" formula?

vlookup means vertical look up, and Hlook up is Horizontal lookup.

You have to practice it, and it is a great tool. The happy news is it is so easy and is not complicated as it seems...

=Vlookup( looking value, range where you wish to find, coloumn no, false & True)

looking Value  always in left most row

range is selected range in which we  wish to search the particular value

Coloum No means the coloumn in range

false & True  if you put0 it willl give exact answer and if you will put1 will give you relevant answer

always use0.

this function is very usefull to retrive required data from many source and to combine for analysis.

1. first arrange all the data's in an excel file (or you can keep in different files)

2. select a blank sheet and use the formula (here data range you can select the sheet where the data is available)

Is a special function to search for a specific value or a specific recipe to search through the reference number of database columns through ( a reference to the search database) 

vlookup(ref , data ,colmun no,false)example 

or 

if(isna(vlookup(ref,data,colmun no,false)=true,0,(vlookup(ref,data,colmun no,false)example

Vlookup is a function in Excel that allows you to type the value of one cell to look up the value of a corresponding cell in the same row.

The V in VLOOKUP stands for vertical (column).When performing a Vlookup, each match found will return the corresponding value on the same row in the next column. For example, if you were looking for a number in a phone book you would read down the list of namesuntil you found the name you were looking for and then move your finger to the right (in the same row) to find the associated phone number.

Use VLOOKUP instead of HLOOKUP when your comparison values are located in a ... An array range shares a common formula

vlookup(lookup-value-table-array-index-number-range-lookup)

looks for a value in the leftmost colum of a table and then returns a value in the same row from a column you specify,the table must be sorted in a ascending order

lookup value:-is the value to be found in the first colum of the table and can be a value a reference ,or text string

table -array:-is a table of text munber ,or logical values in which data is retrieved table -array can be a reference to a range name

co-in-num:-the fist column of values in the table is colum1

range lookup:-true or omitted an exact match -false

 V lookup formula=VLOOKUP(C16,Sheet1!A20:B32,2,0)