Search

# All articles with 'INDEX()' Tag

## What is XLOOKUP and how to use it in Excel?

Published on Mar 12, 2024 in Excel Howtos

Think of XLOOKUP as an improved version of VLOOKUP. In this article, learn all about the XLOOKUP function, it’s syntax, parameters with real-world xlookup examples.

Continue »

## VLOOKUP(), MATCH() and INDEX() – explained in plain English

Published on Feb 11, 2024 in Featured, Learn Excel

VLOOKUP may not make you tall, rich and famous, but learning it can certainly give you wings. It makes you to connect two different tabular lists and saves a ton of time. In my opinion understanding VLOOKUP, INDEX and MATCH worksheet formulas can transform you from normal excel user to a data processing beast. Today, […]

Continue »

## Speed up your Excel Formulas [10 Practical Tips]

Published on Apr 14, 2023 in Excel Howtos, Learn Excel

Excel formulas acting slow? Today lets talk about optimizing & speeding up Excel formulas. Use these tips & ideas to super-charge your sluggish workbook. Use the best practices & formula guidelines described in this post to optimize your complex worksheet models & make them faster.

1. Use tables to hold the data
2. Use named ranges & named formulas
3. Use Dynamic Array formulas
4. Sort your data
5. Use manual calculation mode

… and more. Read on to learn these top 10 tips & ideas to improve performance of your excel formulas.

Continue »

## Write a formula to get Department Budget for a Month [Homework]

Published on Mar 12, 2021 in Excel Challenges

Time for another homework. You got a spreadsheet of department budgets and need to write a formula to get budget for a given department, month combination.

Continue »

## Image Lookup – How-to show dynamic picture in a cell [Excel Trick]

Published on Dec 16, 2020 in Learn Excel

Do you ever want to have an image or picture lookup in Excel? Something like the depiction above.

In this article, learn how to set up an image lookup using Excel. You can use this to display staff details, product images or machine parts etc.

Continue »

## How to make an Interactive Chart Slider Thingy

Ok, I will be honest. I have no idea what to call it. May be Chart Cover Flow? But Interactive Chart Slider Thingy sounds so better. So let’s go with it.

Learn how to create this magical contraption in Excel.

Continue »

## Easy Website Metrics Dashboard with Excel

Published on Apr 28, 2020 in Charts and Graphs, Learn Excel, Templates

Do you run an e-commerce website? You are going to love this simple, clear and easy website metrics dashboard. You can track 15 metrics (KPIs) and visualize their performance. The best part, it takes no more than 15 minutes to setup and use. Here is a preview of the dashboard.

Click to download the template.

Continue »

## Number to Words – Excel Formula

Published on Mar 24, 2020 in Excel Howtos, VBA Macros

Ever wanted to convert numbers to words in Excel? For example, 456,123 becomes four hundred fifty-six thousand one hundred twenty-three.

Microsoft recently introduced LET function to Excel. This allows us to create variables on the fly to use within a formula. I just made a words from number formula using LET function and bit of good old INDEX.

Read on to learn how this all works.

Continue »

## Job Title Matching Problem [Excel Homework]

Published on Aug 30, 2019 in Excel Challenges, Power Query

Howdy folks. Almost the end of August here. Let’s wrap it up with a nice little challenge, inspired from my recent consulting gig. Say you are looking at few job titles that look similar and want to match them to correct title.

Continue »

## VLOOKUP or INDEX+MATCH? – Excel Interview Question – 01

Published on Aug 15, 2019 in Interview Questions, Learn Excel

This is part of our Excel Interview Questions series.

VLOOKUP or INDEX+MATCH? When you should use each function and why?

This is such a great question to ask in interviews. So in my first installment of Excel interview questions, let me answer it.

Continue »

## How to predict cricket scores [Excel + Machine Learning]

Published on Jul 2, 2019 in Analytics, Charts and Graphs, Learn Excel

Can we predict cricket match score in Excel? Using machine learning, ensemble modeling, multiple regression and Excel formulas we can. This tutorial explains how.

Continue »

## VLOOKUP multiple matches – trick

Published on Apr 16, 2019 in Excel Howtos, Learn Excel

We all know that VLOOKUP can find first match and return the results. But what if you want all the matches? Use this simple trick instead.

Continue »

## Lenient lookup [Advanced Formula Trick]

Published on Sep 13, 2018 in Excel Howtos, Learn Excel

We all know VLOOKUP (or INDEX+MATCH) as an indispensable tool in our Excel toolbox. But what if you want the lookups to be a little gentler, nicer and relaxed?

Let’s say you want to lookup the amount \$330.50 against a list of payments. There is no exact match, but if we look 50 cents in either direction, then we can find a match. Here is a demo of what I mean.

Unfortunately, you can’t convince VLOOKUP to act nice.

Hey VLOOKUP, I know you are awesome and all, but can you cut me some slack here?

VLOOKUP is tough, reliable and has a cold heart. Or is it?

In this post, let’s learn how to do lenient lookups.

Continue »

## Create your first interactive chart in Excel with this tutorial

Published on Apr 19, 2018 in Charts and Graphs, Learn Excel, Pivot Tables & Charts

Ever wanted to make a cool, snazzy interactive chart in Excel? Something like this:

In this tutorial, learn all about making your very first interactive chart. We use both formulas and pivot tables to build two versions of an awesome interactive chart in Excel.

Continue »

## Visualizing Commonwealth games performance – Interactive chart

Published on Apr 13, 2018 in Charts and Graphs, Power Query

The 2018 edition of Commonwealth games are on for a week now. Both of my homes – India and New Zealand have been doing so well. Naturally, I wanted to gather games data and make something fun and creative from it. Here is my attempt to amuse you on this Friday.

Looks interesting? Want to know how to make something like this on your own? Then read on…

Continue »

### Get FREE Excel & Power-BI Newsletter

One email per week with Excel and Power BI goodness. Join 100,000+ others and get it free.

#### Downloads

© All rights reserved.