|excel vlookup function||0.11||0.8||9525||77|
VLOOKUP is one of the most useful and important functions in Microsoft Excel. It is generally used to look up a particular value in huge data sheets where manual intervention can be cumbersome. The alphabet ‘V’ in VLOOKUP stands for “Vertical” so this function is sometimes also called vertical lookup.Why to use a VLOOKUP function?
The VLOOKUP function in Excel is used to find something in a table . If you have rows of data organized by column headings, VLOOKUP can be used to locate a value using the column.How to use VLOOKUP formula in Excel?
Use the Vlookup formula in Microsoft Excel to retrieve the names of the students. The vlookup formula in excel is written as follow: =VLOOKUP (Reg. No., in worksheet range, column no. in the worksheet range, [exact/Approximate match]) The above explanation will result in the following: =VLOOKUP (F3,$A$2:$D$21,2,TRUE).