How to Use Index and Match to Replace Vlookup
We’re going to look at replacing Vlookup with the Index and Match functions.
Before we do that though, it is important to note why we would. What is wrong with Vlookup that it needs replacing?
We’re going to look at replacing Vlookup with the Index and Match functions.
Before we do that though, it is important to note why we would. What is wrong with Vlookup that it needs replacing?
In this video I will discuss 9 of the most useful keyboard shortcuts for beginning Excel users. We’ll talk about moving between worksheets, opening the Save as window and selecting entire rows and columns.
There are a ton of ways to round numbers in Excel. Ways you may not have thought of at first, like rounding to the nearest 1000 or truncating a specific number of digits. This page is meant as an overview to find the specific rounding type that you’re looking for.
In this video I’ll show you how to create a simple drop down list in Excel. We do this using a list of countries on another worksheet. We also go into restricting the options and showing hints.
Welcome to the COMPLETE guide on the Excel If function. We’ll go into formulas containing If, nested If statements, AND and OR. The different conditional operators that can make up the conditions of the If function.
A 4 step guide to make Excel export as PDF. Information on how to convert the entire workbook, specific worksheets and an in-depth look at all the other PDF exporting options.
How to remove spaces from Excel workbooks and worksheets. There are quite a few ways of doing this. In this video I’m showing a couple of them. I also show how to remove line breaks or substitute them for something else.
Excel’s find and replace allows you to search for something (a text, a number, all formulas, etc) and replace it with something else. This blog post gives an entire overview of all options there are when finding and replacing in Excel. Wildcards, removing values, finding line breaks and extra options.
It doesn’t have to be difficult: Vlookup, the most infamous function in Excel, explained in less than 2 minutes! We’ll also get into it further with another example and some common questions and pitfalls and how to overcome them.
You’ve worked with Excel a few times. You’ve seen others use it to great effect. And now, it is your time to start on your path to becoming the Excel guru of the office. Welcome to the beginners tips and tricks for Excel. Let’s get right to it. 1. Drag and drop to move A … Read more