How do I match a cell in one document to a range of cells in another document?
For example, the following works when the search item and search region are in the same document:
…It correctly displays the line number of the first occurrence of the matching cell.
However, the following does NOT work when the search item and search region are in different documents:
I am using LibreOffice Calc version 188.8.131.52.
Based on comments, I saved both files as XLSX and checked the cell references. The issue still exists. Here are both the files:
Source File test_a.xlsx
*Column A has the source/needle cells
*Column B has the MATCH formula
Range File test_b.xlsx
*Column A has the range/haystack cells