Learn INDIRECT functions Use INDIRECT when you want to change the reference to a cell within a formula without changing the formula itself. Well explained in this video 163 views18:31