I've attached an example of the file I'm working on.
I would like to keep the data in a separate file. But, offset formulas don't work if the data source is not open on your computer.
I'm using the offset formula because I need to use both Row and Column references to find the data I need in the report.
Is there another formula, or another method, I can use that would allow me to keep the data in a separate file?
