Trying to type out a formula that relates to a different book can be a nightmare – how do you get the file name, the exclamation mark, the apostrophes, etc, all in the right place? Well, why not let Excel do the hard work for you?[youtube https://www.youtube.com/watch?v=YnzIGRAIpK8&hl=en&fs=1]
