I need to get address from anoter book in LO calc. I do that in excell with success, but calc return me a ref error. I use 3 functions: match, index and cell.
calc
=CELL("address";INDEX('file:///C:/Users/vofan/Desktop/new/main_file.xlsx'#$main.H2:H970;MATCH(H2;'file:///C:/Users/vofan/Desktop/new/main_file.xlsx'#$main.H2:H970;0)))
I do that with ctl+shift+enter, and functios works independently but nothink help. Have any ideas?