These five examples showcase how you can use the IF and VLOOKUP nested functions in Excel. There are various other ways that you can use the formula as well. If you want to learn more about Excel and ...

Advanced Excel functions BYROW, MAP, SCAN, ... For example, you can use REDUCE to build an array of results using the VSTACK function and then remove initial empty rows with the DROP function, ...

Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.