Excel Formulas Archives

Everything you need to know about the VLOOKUP() function in Excel

Door Bjorn Meijer November 2, 2023 0

Whether you're analyzing financial data, preparing a sales report, or managing a list of customer information, it's often essential to… Read more

Door Bjorn Meijer Nov 10, 2022 2

Especially with large datasets, it can be an advantage to give the activated row (and possibly column) a different background color… Read more

Door Bjorn Meijer 28 Oct 2022 0

In this article I explain how you can find out based on a date whether it is in… Read more

Door Bjorn Meijer 17 January 2022 0

If you regularly work with Excel, it often happens that you have to add columns or rows of numbers. And… Read more

Door Bjorn Meijer January 4, 2022 0

For example, in Excel you can easily fill a drop-down list with data using a range. If in the… Read more

Door Bjorn Meijer October 14, 2021 0

Introduction Excel is a handy program that you can use not only for working with numbers, but also for… Read more

Door Bjorn Meijer 5 May 2021 0

Vertical search The VLOOKUP() function allows you to search a table or range for a specific value. For example on… Read more