To create dynamic dropdown lists, you typically need to use named ranges and the INDIRECT function in Excel. The function references a range of cells that change based on what you selected in the ...

You can use information you already have in your spreadsheet to create a reference. The reference created using the INDIRECT function will stay the same, even if your sheet's structure changes.

Cross-Sheet Data Calls Google Sheets fully supports calling data from one sheet and using it in another. It's very simple using the INDIRECT function (and other means) and dynamic cell calls (which we ...

For you advanced users who want to skip ahead: You apply the conditional formatting using a custom formula and some variation on the INDIRECT function. In addition to specifying the column and row, ...