what do we mean by V lookup mean in excel ?


2 Answer(s)


The V in VLOOKUP stands for vertical. Use VLOOKUP instead of HLOOKUP when your comparison values are located in a column to the left of the data that you want to find.

-- VLOOKUP function, which stands for vertical lookup, can help you find specific information in large data tables. This function allows you to look up values in a table that are listed in column format, given another value

-- Syntax

VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)


-- Blog to understand Vlookup function

/article/microsoft-excel-tutorial-how-to-use-vlookup-function-part-1-with-exact-match-/57#.Uw85wYVFBAM