INDIRECT formula returns the reference specified by the text string
Note:
– It is a volatile formula (use with caution)
– The Reference Text (ref_text) could be:
— A reference to a cell that in-turn contains a cell reference in A1-style or R1C1-style format
— A reference to a cell in double quotes
— A named range that returns a reference
Live Example here:
Free Excel Course –
Paid Online Training –
Best Excel Books:
⚙️ Gear I Recommend:
Camera –
Screen Recorder – techsmith.z6rjha.net/26D9Q
USB Mic –
Wireless Mic:
Lighting –
Subscribe to get awesome Excel Tips every week:
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
Watch more new videos about Excel Office | Synthesized by Mindovermetal English
Learnt some formula from you, help me a lot, it's awesome, thank you!
Very useful…God bless u!
Thank you! Can INDIRECT function redirect to a worksheet ( within or outside of the workbook)?
https://youtu.be/grPmb5jvWiA. Dore amasomo yubuntu kur Ms Excel Kora subscribe ujye ubona amavideo uko akurikirana kugihe
Bisangize nabandi kuko Hari nabandi babikeneye
thanks
Very understandable
Thanks sir i seen so many videos since last seven days.Now its clear from your videos 😙
TRUMP WTF
Thanks!
NICE
You're really good…I love your channel.
the second & last usage of Index formula didn't work for me. please help me in that.
Please tell me how can I create a sheet that:
1. Can automatically pick sheet names from the same workbook,
2. Go to a specific fixed cell in each sheet to take its total as follow:
Sheet Name Total Amount
Jan 100
Feb 200
Thanks