- match function.png (27.03 KiB) Viewed 6594 times
| Edit: Changed subject, was Why can't use match function? Make your post understandable by others -- MrProgrammer, forum moderator |
[Solved] MATCH function returns Err:502
[Solved] MATCH function returns Err:502
Why can't use match function?
The raw data file in sample.xls.
- Attachments
-
- sample.xls
- (9.5 KiB) Downloaded 23 times
Last edited by luofeiyu on Mon Jan 12, 2026 7:07 am, edited 2 times in total.
LibreOffice 7.4.7.2 on Debian 12
Re: MATCH function returns Err:502
This formula works for me
Notice the . between the sheet name and the cell range.
Also, if you want to put quotes around the sheet name, use single quotes
Code: Select all
=MATCH(A2;sheet2.A2:A4;0)Also, if you want to put quotes around the sheet name, use single quotes
Code: Select all
=MATCH(A2;'sheet2'.A2:A4;0)OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: [SOLVED]MATCH function returns Err:502
If in LibreOffice the formula syntax (Tools ⟶ Options ⟶ LibreOffice Calc ⟶ Formula) is set to "Excel A1",
the formula works.
⠀
the formula works.
⠀
- Excel_A1.png (82.28 KiB) Viewed 6559 times
OpenOffice 1.1.5 – 4.1.16
LibreOffice 3.3.0.4 – 26.2
Windows 7,10,11 64-bit
LibreOffice 3.3.0.4 – 26.2
Windows 7,10,11 64-bit