I hope to get some help here with a problem that I have.
I have a workbook that retrieves information from different workbooks, this all works well.
The main problem I have is when there is more then 1 result.
Please see attached file with a sample.
Just to clarify the sample is retrieving on a different sheet within the same workbook. The solution needs to be that it needs to retrieve that information from a different workbook.
Hope you guys can help me out, I would really appreciated it.