There are many ways to find and retrieve data from a table or range based on a lookup value. In fact, because Microsoft often comes up with new, modernized alternatives, there are too many ways! So, ...

Excel has over 475 formulas in its Functions Library, from simple mathematics to very complex statistical, logical, and engineering tasks such as IF statements (one of our perennial favorite stories); ...

D espite its age, Excel continues to evolve with new functions being added over time. There are newer better Excel functions that you should use instead of the old ones. But, there are also some old ...

Recently, I have been doing quite a bit of work involving the use of functions inside Excel spreadsheets. Although functions are probably most often used for computational purposes, functions can also ...

VLOOKUP and Search are two functions that Excel uses to search for text. VLOOKUP finds data in a column and returns the contents of an adjacent cell. Search finds data in a cell and returns the string ...

Excel boasts a vast library of functions, categorized to suit various purposes: Mathematical Functions: Perform mathematical operations like addition, subtraction, multiplication, division, ...

How to apply multiple filtering criteria by combining AND and OR operations with the FILTER() function in Excel Your email has been sent Applying multiple criteria against different columns to filter ...

There's more to Excel's Subtotal feature than you might realize. You can add multiple subtotaling functions to the same row, and you can add multiple rows. You probably know that Excel’s Subtotal ...

Today at Microsoft's Ignite 2017 conference, the company announced some improvements to Excel during the keynote. They were kind of glossed over, but during a session later on in the day, it expanded ...