Vlookup fast finding data

Vlookup function easily to find data in vertical range. HLOOKUP and VLOOKUP are functions in Microsoft Excel that allow you to use a section of your spreadsheet as a lookup table. When the VLOOKUP function is called, Excel searches for a lookup value in the leftmost column of a section of your spreadsheet called the table array. The function returns another value in the same row, defined by the column index number. HLOOKUP is similar to VLOOKUP, but it searches a row instead of a column, and the result is offset by a row index number. The V in VLOOKUP stands for vertical search (in a single column), while the H in HLOOKUP stands for horizontal search (within a single row). Remember: The lookup value must be in the left-most column of the table array. If not, the lookup function will fail. Make sure that every value in the left-most column of the table array is unique. If you have duplicate values in the column where the lookup takes place, the results of VLOOKUP are not guaranteed to be correct.