0

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?

4
  • Can you specify why you want to get the cell address of of another sheet? It does appear that CELL function doesn't work when referencing outside of the current document. So maybe you'll need to achieve what you want to do in another way.
    – H3coder
    Commented Jun 4 at 1:54
  • @H3coder So, I work with two documents, where are big lists of people. I choose anybody in the first document, and I need to find the same person in the second document. In my case, the best way is to use address in second doc + go to. Macros unavailable
    – Vladimir Kalinin
    Commented Jun 12 at 14:20
  • Yeah, but why you need to get the textual result: 'file:///C:/Users/vofan/Desktop/new/main_file.xlsx'#$main.H10? You know the file name and sheet, why not just use concat to construct the string and then use match to get the row number for you?
    – H3coder
    Commented Jun 19 at 2:34
  • @H3coder, thanks! That what I need
    – Vladimir Kalinin
    Commented Jun 25 at 7:16
Related questions
0
How to solve functions error in LibreOffice Calc
0
LibreOffice Calc: Can I get the cell address from VLOOKUP?
1
LibreOffice Calc, error 509 in if function
Load 6 more related questions Show fewer related questions

0

Reset to default

Browse other questions tagged or ask your own question.