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: https://trumpexcel.com/excel-function...





Free Excel Course - https://trumpexcel.com/learn-excel/
Paid Online Training - https://trumpexcel.com/excel-training/
Best Excel Books: https://trumpexcel.com/best-excel-books/

⚙️ Gear I Recommend:
Camera - https://amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - https://amzn.to/2uzhVHd
Wireless Mic: https://amzn.to/3blQ8uk
Lighting - https://amzn.to/2uxOxRv

Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexc...

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial