INDIRECT Archives - Xelplus - Leila Gharani

Practical Excel Dashboards Tips – Ideas to Get Creative

Leila Gharani — Wed, 11 Dec 2019 03:18:00 +0000

This Excel dashboard combines 4 strange features to create a dynamic and practical dashboard. It includes FILTER function with XLOOKUP, XOR function, Linked Picture as well as an Icon. You'll find a lot of hidden gems in the way this Excel dashboard was created.

The post Practical Excel Dashboards Tips – Ideas to Get Creative appeared first on Xelplus - Leila Gharani.

Lookup on Pictures in Excel

Leila Gharani — Tue, 12 Jun 2018 09:15:00 +0000

Create impressive Excel reports by adding a dynamic lookup to your image. This way, every time a cell value changes, your image changes. Download the Excel Workbook and use it to quickly get started.

The post Lookup on Pictures in Excel appeared first on Xelplus - Leila Gharani.

Data Validation in Excel

Leila Gharani — Thu, 10 May 2018 16:46:00 +0000

Learn how to properly set up data validation in Excel. It's especially useful when you're preparing a data input form, where you require the entered data to meet certain criteria.

The post Data Validation in Excel appeared first on Xelplus - Leila Gharani.

Lookup Values Across Multiple Worksheets in Excel

Leila Gharani — Fri, 17 Nov 2017 07:40:00 +0000

In this tutorial, we will address how to lookup values in multiple tabs using a single formula. You will see one method using VLOOKUP and direct worksheet and cell references, and another using INDEX & MATCH and Excel Table names and references. Both approaches rely on the INDIRECT function to return the correct sheet address in a dynamic way.

The post Lookup Values Across Multiple Worksheets in Excel appeared first on Xelplus - Leila Gharani.

Excel INDIRECT Function

Leila Gharani — Tue, 28 Mar 2017 11:51:00 +0000

The INDIRECT() function comes very handy when need to feed different ranges to certain formulas, especially when you refer to ranges in other sheets. This tutorial explains how the INDIRECT() function works and how to use in a real-life scenario, gathering data from different tabs.

The post Excel INDIRECT Function appeared first on Xelplus - Leila Gharani.

Dependent Drop Down Lists in Excel

Leila Gharani — Thu, 23 Mar 2017 09:46:00 +0000

Learn how to create dependent dropdown list in Excel lists using the INDEX, OFFSET, CHOOSE and INDIRECT functions.

The post Dependent Drop Down Lists in Excel appeared first on Xelplus - Leila Gharani.

Excel Arrays: Count Unique Items with MMULT, INDIRECT & ROW Functions (Part 3/3)

Leila Gharani — Wed, 01 Feb 2017 09:10:00 +0000

Consider a scenario, where you need to return a unique count across rows rather than column. You could use the TRANSPOSE function, but in older versions of Excel, TRANSPOSE requires pressing Control Shift Enter (CSE). If you'd rather avoid it, but keep the solution dynamic, you need to look for an alternative. In this tutorial, you will find 3 different solutions based around the ROW function - in combination with INDIRECT, INDIRECT & ADDRESS, and INDEX.

The post Excel Arrays: Count Unique Items with MMULT, INDIRECT & ROW Functions (Part 3/3) appeared first on Xelplus - Leila Gharani.