ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

Dini  Damayanti
من قبل 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

Amir Khan
من قبل Amir Khan

but i think it is used to find a specific value am i wrong?

Faisal Shehzad
من قبل 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
من قبل 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
من قبل 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
من قبل 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
من قبل Danial Gul Faridi , Accountant , Serioplast Pakistan (Pvt.) Ltd.

For finding data with a easy way.

Syed Farhan Mohiuddin
من قبل Syed Farhan Mohiuddin , ACCOUNTANT , IKLIL COMPUTER TECHNOLOGY

summaries and easliy and speed ll b increased in excell work

Renu Jajoo
من قبل 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
من قبل Sakkeer Thaivecha Parambath , Finance Officer , Qatar Airways

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

المزيد من الأسئلة المماثلة

هل تحتاج لمساعدة في كتابة سيرة ذاتية تحتوي على الكلمات الدلالية التي يبحث عنها أصحاب العمل؟