What is the VLOOKUP function mainly used for in MS Excel 365?
What is the VLOOKUP function mainly used for in MS Excel 365?
एमएस एक्सेल 365(MS Excel 365) में VLOOKUP फ़ंक्शन का उपयोग मुख्य रूप से किसलिए किया जाता हैं?
Detailed Solution & Logic
Correct Answer:
To search a value in a table and return the corresponding value/किसी टेबल में कोई वैल्यू खोजने और संगत वैल्यू प्रदान करने के लिए
VLOOKUP (Vertical Lookup) is one of the most commonly used functions in MS Excel.
It searches for a value in the first column of a table and then returns a value from another column in the same row.
Example: If you have a list of product IDs and prices, you can use VLOOKUP to find the price of a specific product ID.
Key Takeaway
VLOOKUP is mainly used for looking up data vertically in a table and retrieving related information, not for totals, percentages, or pivot tables.
Similar Practice Questions
Which command in Windows 10 CMD
Which command in Windows 10 CMD will delete all .log files in the current directory...
In MS Excel, which tab is generally used to open and save a spreadsheet?
In MS Excel, which tab is generally used to open and save a spreadsheet? एमएस...
In a multitasking operating system, what role does
In a multitasking operating system, what role does RAM primarily play when multiple applications are...
In MS Excel 365 which of the following
In MS Excel 365 which of the following shortcut keys is used to select entire...
In MS Word, if you press the TAB key in a table, where will the cursor move?
In MS Word, if you press the TAB key in a table, where will the...
What is the main objective of network security?
What is the main objective of network security? नेटवर्क सिक्योरिटी का मुख्य उद्देश्य क्या है?
What is the keyboard shortcut for copying text in MS Word?
What is the keyboard shortcut for copying text in MS Word? MS वर्ड में टेक्स्ट...