Register now or log in to join your professional community.
Vlook Is a commonly used reference function in Microsoft Excel. to organize the data
if you have a list of products with prices, you could search for the price of a specific item
but i think it is used to find a specific value am i wrong?
Simply it is an vertical search tool in Excel. In detail its used to extract specific information, sparing user the need to search for each item individually we can find the items ina difeerent row having huge data into our sheet without finding every other data
vertical lookup, advance filter out from the selected table, display the selected data as on function
If you have a one column of major data and correspondings of this, and if you have another minor data which is included in this major data, and if you want to see the correspondings of minor data, you use Vlookup formula to make it happen.
For finding data with a easy way.
summaries and easliy and speed ll b increased in excell work
The VLOOKUP function performs a vertical lookup by searching for a value in the first column of a Table and returning the value in the same row in the index number position.(Of column)
V look up is used to compare Vertical values or column values from another sheet
