Hi all,

I've tried to have a solution and did not found it yet. I need a formula to consolidate data from external references - and this is easy. But rows are related to different colleagues that have their own files with their name and the row order may change in their files.

What is the best formula to consider the external file name based on a cell text value from the consolidation workook?

For details please see attachment.

Thank you.
Sorin
excel.jpg