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 …
Continue reading Lookup data in single row or column with Excel Lookup functionExcel Functions
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 …
Continue reading Row lookup using HLOOKUP function in ExcelExcel 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 …
Continue reading Error Handling using IFERROR function in ExcelExcel 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 …
Continue reading Rounding number to the nearest multiple using MROUND in ExcelAVERAGEA 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 …
Continue reading Excel AVERAGEA function