Gowri Shankar SS

Use VLOOKUP, one of the lookup and reference functions, when you need to find things in a table or a range by row. For example, look up a price of an automotive part by the part number. In its simplest form, the VLOOKUP function says: =VLOOKUP(Value you want to look up, range where you want to lookup the value, the column number in the range containing the return value, Exact Match or Approximate Match – indicated as 0/FALSE or 1/TRUE). Use the VLOOKUP function to look up a value in a table. Syntax VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup]) For example: =VLOOKUP(105,A2:C7,2,TRUE) =VLOOKUP("Fontana",B2:E7,2,FALSE) Argument name Description lookup_value     (required) The value you want to look up. The value you want to look up must be in the first column of the range of cells you specify in   table-array   . For example, if   table-array   spans cells B2:D7, then your lookup_value must be in column B. See the graphic be

Use LOOKUP, one of the lookup and reference functions, when you need to look in a single row or column and find a value from the same position in a second row or column. For example, let's say you know the part number for an auto part, but you don't know the price. You can use the LOOKUP function to return the price in cell H2 when you enter the auto part number in cell H1. There are two ways to use LOOKUP: Vector form and Array form Vector form: Use this form of LOOKUP to search one row or one column for a value. Use the vector form when you want to specify the range that contains the values that you want to match. For example, if you want to search for a value in column A, down to row 6. Array form: We strongly recommend using VLOOKUP or HLOOKUP instead of the array form. Watch this video about using VLOOKUP. The array form is provided for compatibility with other spreadsheet programs, but it's functionality is limited. An array is a collection of values

Summary  The Excel SUM function returns the sum of values supplied as multiple arguments. SUM can handle up to 255 individual arguments, which can include numbers, cell references, ranges, arrays, and constants. Purpose Add numbers together Return value  The sum of values supplied. Syntax  =SUM (number1, [number2], [number3], ...) Arguments  number1 - The first item to sum. number2 - [optional] The second item to sum. number3 - [optional] The third item to sum. Example Here’s an example. To add the January numbers in this Entertainment budget, select cell B7, the cell immediately below the column of numbers. Then click AutoSum. A formula appears in cell B7, and Excel highlights the cells you’re totaling. Press Enter to display the result (95.94) in cell B7. You can also see the formula in the formula bar at the top of the Excel window.

Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS . It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has replaced Lotus 1-2-3 as the industry standard for spreadsheets. Excel forms part of the Microsoft Office suite of software. Basic Excel Formulas Guide Mastering the basic Excel formulas is critical for beginners to become highly proficient in financial analysis. Microsoft Excel is considered the industry standard piece of software in data analysis. Microsoft’s spreadsheet program also happens to be one of the most preferred software by investment bankers and financial analysts in data processing, financial modeling, and presentation. This guide will provide an overview and list of basic Excel functions. Basic Terms in Excel There are two basic ways