Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Dini  Damayanti
par Dini Damayanti , Administration Head , FORD AUthorized - Kreasi Auto Kencana. PT

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?

Faisal Shehzad
par Faisal Shehzad , network and system support engineer , UOL CHENAB CAMPUS

V lookup command used to delete any duplicate row by comparing sheets and generate a final sheet

Zain Ashfaq Balagamwala
par Zain Ashfaq Balagamwala , Assistant Manager Finance , BSL Private Limited

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

Birendra Shrestha
par Birendra Shrestha , Sales Associate , Apparel Group LLC

vertical lookup, advance filter out from the selected table, display the selected data as on function

Ziya Anil Atman
par Ziya Anil Atman , Senior Tax Auditor , Deloitte Touche Tohmatsu

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.

Danial Gul Faridi
par Danial Gul Faridi , Accountant , Serioplast Pakistan (Pvt.) Ltd.

For finding data with a easy way.

Syed Farhan Mohiuddin
par Syed Farhan Mohiuddin , ACCOUNTANT , IKLIL COMPUTER TECHNOLOGY

summaries and easliy and speed ll b increased in excell work

Renu Jajoo
par Renu Jajoo , Finance Manager , Pyramid Pharma Limited

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)

Sakkeer Thaivecha Parambath
par Sakkeer Thaivecha Parambath , Finance Officer , Qatar Airways

V look up is used to compare Vertical values or column values from another sheet

More Questions Like This