Lookup data in single row or column with Excel Lookup function

Excel Lookup function   With Lookup function, you need to look in a single row or column and find a value from the same position in a second row or column.   Looking up data in multiple rows/columns using LOOKUP is discouraged, the VLOOKUP function should be preferred instead.   So, use this for looking up data […]

Row lookup using HLOOKUP function in Excel

Excel HLOOKUP function   HLOOKUP stands for Horizontal lookup. It looks for a value horizontally, i.e, in a row.   HLOOKUP helps in looking up data in a row across the top of the table.   It searches for a value in the top row of a table or an array of values, and then […]

Error Handling using IFERROR function in Excel

Excel IFERROR function   IFERROR function is used to captures and handles errors occurred while executing a formula.   IFERROR function returns specified value if the formula results in an error, otherwise it returns the result of the formula.   So, it works as a error handling step for your formula.. it shows a user […]

Rounding number to the nearest multiple using MROUND in Excel

Excel MROUND function   MROUND function rounds a number to the nearest multiple of the specified number.   Example :   MROUND(10,3)   Nearest multiple of 3 to 10 is 3*3 = 9.   So, MROUND(10,3) = 9   Formula   =MROUND(number, multiple)   The MROUND function syntax has the following arguments:   number is […]

Excel AVERAGEA function

AVERAGEA function in Excel   AVERAGEA function in Excel returns the average(Arithmetic Mean) of its arguments.   It considers Text and FALSE(boolean) as 0.   It considers TRUE(boolean) as 1.   Formula   =AVERAGEA(value1, [value2], …)   Here, value1, value2, …    are the values on which average will be calculated. Atleast one value is […]