Dynamic References Based on Two Criteria (INDIRECT OR VLOOKUP?)

Originally Posted by Richard Buttrey

Hi,

INDIRECT() won't work with closed workbooks. Why not have a macro that opens the workbook and then builds the Indirect() functions?

Made a rookie typo - it's all in one workbook and I'm referencing different sheets. Hopefully that can make it work without having to dive into macros (I'm net quite there yet!).