Ms excel vlookup tutorial in hindi. The video tutorials for both ms excel and word are extremely easy to understand and i learnt so much just superb tushar i graduated 5 months ago and was trying to get a job in the software industry i found out about learnvern and started software testing course in a week i had completed the course and appeared for 3 job interviews and landed. Approximate match 1true assumes the first column in the table is sorted either numerically or alphabetically and will then search for the closest value. Computer tips in hindi excel tips in hindi autocad tutorial in hindi tally tips in hindi word tips microsoft excel formula excel tutorial. With this microsoft excel hindi notes you can organize your data and perform mathematical calculations quicklyms excel notes in hindi pdf ms excel notes in hindi free download.
Use the match and vlookup functions in microsoft excel. Learn ms excel hindi with ms excel notes in hindi. Vlookup v stands for vertical is an in built function in excel which allows establishing a relationship between different columns of excel. I l vlookup il e vlookup.
This is the default method if you dont specify one. Vlookup is a look up tool which brings the. In this video we will learn simple use of vlookup and learn it in very simple and easy manner. About ms excel in hindi.
How excel vlookup function works. Vlookup in ms excel in hindi. Microsoft excel vlookup function to assign discounts based on difference between. Microsoft excel topic 1 vlookup function.
Learn microsoft excel in hindi. How to use vlookup. Vlookup also known as vertical lookup allows you to locate or lookup another data value in the same row but another column for a data value in the first colu.