I cannot make an external file ref work with either Match or INDEX. For example I have this:
=MATCH(B5,a4:a10,0) it works
But as soon as I replace the range with an external reference it doesn’t, I get N/A. The value is definitely in the external range. To insert the reference I go to the external file, highlight the range and select it.
The file ref looks like this:
'file:///C:/Users/Liz/Google Drive/Temp/FileName.ods'#$'Process H'.O387:O390
I read something that suggest a null string ("")added to the end might help but it doesn’t. Do I need to do something else to this reference?