Excel INDIRECT Function: Lookup Values in Different Sheets / Excel Tabs

Share this & earn $10
Leila Gharani
Published at : 04 Sep 2021
353750 views
3469
111

Easy explanation of Excel’s INDIRECT Function - How to use it and when to use it. Also what to watch out for when you’re using it.

INDIRECT can be very useful in Excel Dashboards when you need a dynamic cell reference instead of hard-coding the reference in a formula. For example, let’s say you have a drop down where the user can select for which year the revenue should be shown. Depending on the selection the formula with a SUMIF or SUMIFS function should sum up different ranges of data. Instead of writing a long formula with different conditions for each year that could be chosen, you can use INDIRECT.

Get the full Excel Dashboard course here: https://courses.xelplus.com/p/professional-excel-dashboards

Indirect can be a confusing function. It takes a little bit time to get the hang of it. What Indirect does, is it returns an address. So for example, if you type in =indirect(A1) and inside A1, you have written A10 - then your formula returns what is inside A10. Why would you need this? Watch the full video and download the workbook to practice along.

Download the workbook here: http://www.xelplus.com/excel-indirect-function/

★ My Online Excel Courses ► https://www.xelplus.com/courses/

✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/

Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593

GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U

More resources on my Amazon page: https://www.amazon.com/shop/leilagharani

Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#MsExcel

Excel Indirect functionINDIRECT formulaINDIRECT

Mills - The Store (Official Video)

Mills - The Store (Official Video)

Malú Trevejo Instagram live Stream October 21, 2021

Malú Trevejo Instagram live Stream October 21, 2021

What is Capacity? | Math | Grade-3 | Tutway |

What is Capacity? | Math | Grade-3 | Tutway |

The Bull Market Is Still Intact | Stock Market Analysis

The Bull Market Is Still Intact | Stock Market Analysis

We might have a problem with the Brakes... - Electric Hummer Conversion!

We might have a problem with the Brakes... - Electric Hummer Conversion!

3 Step Continuity Test, Discontinuity, Piecewise Functions & Limits

3 Step Continuity Test, Discontinuity, Piecewise Functions & Limits

Lykke Li - Possibility // Tradução

Lykke Li - Possibility // Tradução

Tory Lanez - A Woman

Tory Lanez - A Woman

Work together with purchasers - Purchasing Management - Sales Training by Professional Capital

Work together with purchasers - Purchasing Management - Sales Training by Professional Capital

Ronaldo, Cavani & Rashford seal vital win | Highlights | Tottenham Hotspur 0-3 Manchester United

Ronaldo, Cavani & Rashford seal vital win | Highlights | Tottenham Hotspur 0-3 Manchester United

This is Your Period in 2 Minutes | Glamour

This is Your Period in 2 Minutes | Glamour

Speak (2004) Película Subtitulada Español

Speak (2004) Película Subtitulada Español

Static & Ben El, Pitbull - Further Up (Na, Na, Na, Na, Na) (Official Video)

Static & Ben El, Pitbull - Further Up (Na, Na, Na, Na, Na) (Official Video)

Why Tecnam P2006T is an Excellent Four-seat Light Twin

Why Tecnam P2006T is an Excellent Four-seat Light Twin

On the Senate prohibiting the headscarf, the Minister of Interior attacking a Turkish Mosque

On the Senate prohibiting the headscarf, the Minister of Interior attacking a Turkish Mosque

Twakiriye Bamenya ,Alliah,Baraka ,Prosper Nkomezi muri Sunday Choicelive,Phil Peter,M Irene na Moses

Twakiriye Bamenya ,Alliah,Baraka ,Prosper Nkomezi muri Sunday Choicelive,Phil Peter,M Irene na Moses

Can you enhance that? Single Image Super Resolution - Katarzyna Kańska

Can you enhance that? Single Image Super Resolution - Katarzyna Kańska

HELPFUL IDEAS TO MAKE ANY TRIP EASIER

HELPFUL IDEAS TO MAKE ANY TRIP EASIER

What They Have Realized About This Connection☀️🤯🌈| PICK A CARD🔮 In-Depth Love Tarot Reading

What They Have Realized About This Connection☀️🤯🌈| PICK A CARD🔮 In-Depth Love Tarot Reading

Pujaan Hati - The Spouse (OST Perempuan Tanah Jahanam)

Pujaan Hati - The Spouse (OST Perempuan Tanah Jahanam)

20th Boys - ONWAYZ

20th Boys - ONWAYZ

Unintentionally Terrifying Children's Videos

Unintentionally Terrifying Children's Videos

#How to Supervise People - Part 1# Supervision and Leadership

#How to Supervise People - Part 1# Supervision and Leadership

Mind-blowing Variety of Life on Earth | #Attenborough90 | BBC Earth

Mind-blowing Variety of Life on Earth | #Attenborough90 | BBC Earth

The long run, an inside view

The long run, an inside view

P!nk - Just Like A Pill (Official Video)

P!nk - Just Like A Pill (Official Video)

😱😱😱 This is a great way to firm up your skin #makeup

😱😱😱 This is a great way to firm up your skin #makeup

Barely 21 and Morbidly Obese | Fat Doctor | Only Human

Barely 21 and Morbidly Obese | Fat Doctor | Only Human

Palestine... Fully Furnished اخدوها مفروشة Akhaduha Mafroosheh

Palestine... Fully Furnished اخدوها مفروشة Akhaduha Mafroosheh

The blues man: by The Grins

The blues man: by The Grins

Niall Horan - Too Much To Ask (Official)

Niall Horan - Too Much To Ask (Official)

11 Manipulation Tactics - Which ones fit your Personality?

11 Manipulation Tactics - Which ones fit your Personality?

Is It Advisable to Invest the Money You Need in 2 Years in Digital Banks?

Is It Advisable to Invest the Money You Need in 2 Years in Digital Banks?

Madonna - 14. Has To Be

Madonna - 14. Has To Be

Inflammation - causes, symptoms, diagnosis, treatment, pathology

Inflammation - causes, symptoms, diagnosis, treatment, pathology

Empire Of The Sun - We Are The People (Official Music Video)

Empire Of The Sun - We Are The People (Official Music Video)

The Circulatory System Part 1: The Heart

The Circulatory System Part 1: The Heart

Let's Go Make A Memory

Let's Go Make A Memory

We're BAD Students in Roblox High School!

We're BAD Students in Roblox High School!

John Farnham - You're the Voice (Official Video)

John Farnham - You're the Voice (Official Video)

Leonard Mlodinow - Must the Universe Contain Consciousness?

Leonard Mlodinow - Must the Universe Contain Consciousness?

Dave Brubeck Quartet & RNO - To Hope! A Celebration. Mass Moscow 1997

Dave Brubeck Quartet & RNO - To Hope! A Celebration. Mass Moscow 1997

Werewolves VS Vampires | Who is better? || Monsters in My School by Teen-Z

Werewolves VS Vampires | Who is better? || Monsters in My School by Teen-Z

7 Pricing Strategies - How To Price A Product

7 Pricing Strategies - How To Price A Product

how to live a desirable life

how to live a desirable life

Recognition

Recognition

WANT vs. WON'T Pronunciation - American English

WANT vs. WON'T Pronunciation - American English

Your Beloved

Your Beloved

OCD and Anxiety Disorders: Crash Course Psychology #29

OCD and Anxiety Disorders: Crash Course Psychology #29