Awareinfotech

How to use VLOOKUP function VLOOKUP function (MS EXCEL) What is VLOOKUP? VLOOKUP is an Excel function to lookup and retrieve data from a specific column in table. VLOOKUP supports approximate and exact matching, and wildcards (*?) for partial matches. The "V" stands for "vertical" , Lookup values must appear in the first column of the table, with lookup columns to the right. Lookup a value in a table by matching on the first column. Syntax =VLOOKUP(lookup_value,table_array,col_index_num,[range_lookup]) Example. Do the following steps 1st Step Enter your Data in EXCEL WORKSHEET. Example. 2nd Step Enter VLOOKUP function Press enter. And if you want to DRAG this function. Then you can do. But if you have error like that For Example. THIS IS THE PROBLEM OF TABLE ARRAY YOU CAN FIX THE TABLE ARRAY   YOU CAN ALSO DRAG THIS FORMULA.

AutoCorrect Options (MS WORD) What is AutoCorrect Options? Some times MS Word change a word with wrong spelling into correct spelling. This features is known as AutoCorrect entry do the following steps. 1st Step Click on file tab. 2nd Step Select options. 3rd Step Select proofing. 4th Step Select AutoCorrect Options Button. 5th Step   Check text as you type. 6th Step Make Your entry. 7th Step Click add Button. 8th step Click ok. If you want see the video of this content