Hi! Excel Professionals.
In need of help in regards to Index Match array with dynamic reference using INDIRECT function, have attached two files that is relative to each other.
first file consolidate,
-have successfully using indirect function data within workbook (balance sheet)
Second file STATUS,
-failed using same formula structure to get dynamic reference.
for reference: I left some notes for further observation.
Thank you hoping for a response.