For what purpose vlookup is used in Ms excel?

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