Excel 2024 Indirect Characterization. So you create a named range with the =indirect(sheet!&e2&:&e3) part and then use that name. Learning how to use the indirect function in excel can make your spreadsheets more dynamic.

Learn about the latest updates to excel for web and windows, including copilot, copying and pasting, sharing sheet views, and ink to text pen. In excel 2016 at least, you can use indirect with a full path reference;