This is where the INDIRECT function comes in handy. Excel's INDIRECT function turns a text string into a reference. This function has several practical benefits: It allows you to create dynamic ...