It looks like there have been similar questions in this forum about this
age-old problem. I found Pascal 's posting on 9/12/2007 suggesting a
combination of "address" and "match" formula.

So if I take your alternative of a bridge workbook in which I apply the
=address(match....) functions, then I can can translate these cells into the
final output workbook with direct (relative or absolute) references to the
original cells in the source workbook.