I'm trying to set up an array to look up data on a "closed" workbook. The
workbook name varies depending on data entered on the primary sheet.
(example)
I have workbopok "Sales" Open. in cell A1 I have the reference workbook
name "July". The array would find data in the July workbook while it is
closed and import into B1 in Sales Workbook.
Next month cell A1 would read "August" and look up data in the August
Workbook.
I have tried INDIRECT(CONCATENATE($A1,M21)) A1 is the workbook name and M21
contains the values to find.
Any suggestions you can provide are greatly appreciated.