Forum Discussion
IFS(AND()) ACROSS MULTIPLE WORKBOOKS
I need to have a cell search multiple workbooks and based on criteria matching the original workbook will return the contents of another cell in the matching worksheet of that workbook. Example:...
This is something that gets easier with 365 and the stacking functions available. However, dynamic arrays (and INDIRECT, for that matter) require the workbooks to be open. Otherwise, a #REF! error may happen on refresh.
I suspect this might be something better suited for PowerQuery.
I suspect this might be something better suited for PowerQuery.