Excel VLOOKUP Function | Excel Function |
#ExcelTutorial #MicrosoftExcelTutorial #Excel #microsoftexceltutorialyoutube #microsoftexcel #advanceexcel #exceltutorial #vlookup
In this Microsoft excel tutorial, you will learn how to use VLOOKUP function.
Following topics are covered in this video:
1) Excel in-build VLOOKUP Function
00:00:37 -- Demo
📌 Do subscribe to "The Ultimate Guide for Excel Macro" channel & get regular updates on videos: https://www.youtube.com/channel/UCMhe...
In Case you want you master Excel VBA, please refer to "Excel VBA Tutorial" playlist of the same channel.
VLOOKUP :-
Pros:-
1) Can easily do the row level search.
Cons:-
1) In case no result is found, it throws #N/A error. (To cater it, we can further use IFERROR excel function in case if we don't want #N/A to be appeared)
2) As it works on Table array, the return value column should always be on the right hand side of the search value column. Also, the table array has to be a continuous range of columns with no column gap.
Because of above drawbacks, now a days, XLOOKUP (the more advanced version of VLOOKUP) function is used.
Why Microsoft excel is important?
i) Microsoft Excel is the most-used spreadsheet program in the world.
ii) Excel can perform formula-based calculations and many other mathematical functions.
iii) The program also serves as a programming platform for Visual Basic for Applications.
iv) Because of its utility, Excel has become a staple in many enterprises.
Why should you opt for a Microsoft excel career?
i) Microsoft Excel has proven to be advantageous for day to day business activities.
ii) The knowledge of Microsoft Excel has become essential for small business establishments to carry out their day to day business and reap the best results from their business.
iii) There is a huge demand for Excel certified professional.
Watch video Excel VLOOKUP Function | Excel Function | online without registration, duration hours minute second in high quality. This video was added by user The Ultimate guide for Excel 28 November 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 267 once and liked it 11 people.