Reference to different sheets inside Excel formula WITHOUT using IF.
on channel: AuditExcel Advanced Excel and Financial Model Training and Consulting
00:00 Introducing the INDIRECT function
00:23 Make Excel go to a cell reference on the SAME sheet
01:50 Make Excel go to a named cell (name range instead of cell reference)
02:18 Create the cell reference with a formula
03:40 Use INDIRECT to use different sheets in a formula
03:50 Use ADDRESS to create a valid Excel reference ACROSS sheets
04:40 Combine INDIRECT and ADDRESS
How to reference an Excel formula to look at different sheets depending on the contents of another cell using the Sheet name ( no more IF then IF then type formula).
On this page of the site you can watch the video online Reference to different sheets inside Excel formula WITHOUT using IF. with a duration of hours minute second in good quality, which was uploaded by the user AuditExcel Advanced Excel and Financial Model Training and Consulting 18 August 2013, share the link with friends and acquaintances, this video has already been watched 11,729 times on youtube and it was liked by 14 viewers. Enjoy your viewing!
