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

Share this & earn $10
Leila Gharani
Published at : 12 Oct 2021
363957 views
3562
118

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

Sergey Lazarev - Instantly (Lyrics)

Sergey Lazarev - Instantly (Lyrics)

Name A Price - Κώστας & Γιάννος [Guest Λούης Νικολάου] | Ε202

Name A Price - Κώστας & Γιάννος [Guest Λούης Νικολάου] | Ε202

Imany - You Will Never Know (Clip Officiel)

Imany - You Will Never Know (Clip Officiel)

Dirty Three - Obvious is Obvious

Dirty Three - Obvious is Obvious

Eightvo

Eightvo

Clever Classrooms

Clever Classrooms

Stop, Lucy! Don't Catch Wobbly Tooth In Jail! - Wolfoo Learns Good Habits for Kids | Wolfoo Family

Stop, Lucy! Don't Catch Wobbly Tooth In Jail! - Wolfoo Learns Good Habits for Kids | Wolfoo Family

MEDICINE - QUEEN NAIJA  (OFFICIAL VIDEO)

MEDICINE - QUEEN NAIJA (OFFICIAL VIDEO)

🥰 New Gadgets & Versatile Utensils For Home # 376🏠Appliances, Make Up, Smart Home, New Home Items

🥰 New Gadgets & Versatile Utensils For Home # 376🏠Appliances, Make Up, Smart Home, New Home Items

LOW IMPACT home cardio workout - fat burner - NO EQUIPMENT!

LOW IMPACT home cardio workout - fat burner - NO EQUIPMENT!

Logan Mize - "Who Didn't" (Official Audio)

Logan Mize - "Who Didn't" (Official Audio)

Is Xavi the best choice to manage Barcelona? | ESPN FC

Is Xavi the best choice to manage Barcelona? | ESPN FC

Grey River & The Smoky Mountain - Live to tell the tale [Official Music Video]

Grey River & The Smoky Mountain - Live to tell the tale [Official Music Video]

View Point | Imran Yaqub Khan | Zafar Hilaly | GNN | 07 November 2021

View Point | Imran Yaqub Khan | Zafar Hilaly | GNN | 07 November 2021

Aside From That - Hollow Shell (Official Music Video)

Aside From That - Hollow Shell (Official Music Video)

AAP Expelled two leaders who demanded money for allotting seats

AAP Expelled two leaders who demanded money for allotting seats

How to Start (And Grow) a Blog in 2021

How to Start (And Grow) a Blog in 2021

People Who Got Caught In 4k

People Who Got Caught In 4k

I HATE THIS STUPID GAME.. | Stick With It | Fan Choice Friday

I HATE THIS STUPID GAME.. | Stick With It | Fan Choice Friday

Gavin Magnus - "Personal" (Official Music Video)

Gavin Magnus - "Personal" (Official Music Video)

Enrique Iglesias - Maybe (Official Video)

Enrique Iglesias - Maybe (Official Video)

D-Devils - 6th Gate

D-Devils - 6th Gate

The Royal Enfield Himalayan makes an elegant street bike  ...

The Royal Enfield Himalayan makes an elegant street bike ...

A Day in the Life of an Architect | Architecture vlog

A Day in the Life of an Architect | Architecture vlog

What is Normally?

What is Normally?

6 most famous places to drink and luxuriate in beer round the world

6 most famous places to drink and luxuriate in beer round the world

Squid Game This pose VS Among Us is not appropriate for THIS KID

Squid Game This pose VS Among Us is not appropriate for THIS KID

Make Sure to Tell Your Lawyer This.

Make Sure to Tell Your Lawyer This.

SOMI (전소미) - 'ANYMORE' Lyrics [Color Coded_Eng]

SOMI (전소미) - 'ANYMORE' Lyrics [Color Coded_Eng]

Fiend - Only a few

Fiend - Only a few

Install Linux instead of Windows 11 - Here's how!

Install Linux instead of Windows 11 - Here's how!

Ayzha Nyree - No Guidance (Remix) (Lyrics) - Before i die I’m tryna f you baby

Ayzha Nyree - No Guidance (Remix) (Lyrics) - Before i die I’m tryna f you baby

THIS NATALIA ONE SHOT BUILD WILL MAKE YOU A BEAST | Top Global Natalia Gameplay - MLBB

THIS NATALIA ONE SHOT BUILD WILL MAKE YOU A BEAST | Top Global Natalia Gameplay - MLBB

Akiem Hicks Breaks Down How to Make O-Linemen Look SILLY | NFL Film Session

Akiem Hicks Breaks Down How to Make O-Linemen Look SILLY | NFL Film Session

Snail Mail - Thinning [OFFICIAL VIDEO]

Snail Mail - Thinning [OFFICIAL VIDEO]

Lil Quill - Sturdy (Official Music Video)

Lil Quill - Sturdy (Official Music Video)

Taylor Swift - the 1 (Official Lyric Video)

Taylor Swift - the 1 (Official Lyric Video)

Good Spot Family w Karpaczu

Good Spot Family w Karpaczu

Cleveland Chinese Music Ensemble -- Flowers and Youngsters

Cleveland Chinese Music Ensemble -- Flowers and Youngsters

Gentle Rain 10 Hours High Quality

Gentle Rain 10 Hours High Quality

What is an Indicator

What is an Indicator

Michael Jackson - Heal The World (Official Video)

Michael Jackson - Heal The World (Official Video)

Setting Out

Setting Out

Join the Math class - acquire the basic knowledge of the new subject with Professor Ramin Molaei

Join the Math class - acquire the basic knowledge of the new subject with Professor Ramin Molaei

Bear In Mind เก็บฉันเอาไว้ (Shortfilm : SUB ENG )

Bear In Mind เก็บฉันเอาไว้ (Shortfilm : SUB ENG )

Chicago - You're The Inspiration (Lyrics)

Chicago - You're The Inspiration (Lyrics)

This Text Will Make You Cry Your Heart Out.. 😔

This Text Will Make You Cry Your Heart Out.. 😔

LuvBug - Best Is Yet To Come

LuvBug - Best Is Yet To Come

INSECTS FOR KIDS Learning – Insect Names and Sounds for Children, Toddlers, Kindergarten & Preschool

INSECTS FOR KIDS Learning – Insect Names and Sounds for Children, Toddlers, Kindergarten & Preschool