Skip to main content
added 455 characters in body
Source Link
tohuwawohu
  • 10.8k
  • 1
  • 37
  • 65

Since the formula's structure looks ok, it may be a problem of Function separators. I don't have dutch l11n installed, so i can't test this myself. You may check the formula separators (; or ,) using Tools -> Options -> LibreOffice Calc -> Formula. This is the setting for en_us localization:

enter image description here

If this isn't the reason, you could try to create the formula from scratch using the formula wizard. Since the wizard displays interim results, it may be helpful to narrow down the problem.

EDIT:

The result #N/A is thrown if there's no exact match for the search criteria. So i assume it's not a matter of finding the result value in Column I but in finding a match for 1269 in Column A. A reason for this may be if the search criteria isn't a number but a string containing a number (the cell content would be '1269 instead of 1269 (notice the apostrophe). OpenOffice won't match the string 1269 with the number 1269.

Since the formula's structure looks ok, it may be a problem of Function separators. I don't have dutch l11n installed, so i can't test this myself. You may check the formula separators (; or ,) using Tools -> Options -> LibreOffice Calc -> Formula. This is the setting for en_us localization:

enter image description here

If this isn't the reason, you could try to create the formula from scratch using the formula wizard. Since the wizard displays interim results, it may be helpful to narrow down the problem.

Since the formula's structure looks ok, it may be a problem of Function separators. I don't have dutch l11n installed, so i can't test this myself. You may check the formula separators (; or ,) using Tools -> Options -> LibreOffice Calc -> Formula. This is the setting for en_us localization:

enter image description here

If this isn't the reason, you could try to create the formula from scratch using the formula wizard. Since the wizard displays interim results, it may be helpful to narrow down the problem.

EDIT:

The result #N/A is thrown if there's no exact match for the search criteria. So i assume it's not a matter of finding the result value in Column I but in finding a match for 1269 in Column A. A reason for this may be if the search criteria isn't a number but a string containing a number (the cell content would be '1269 instead of 1269 (notice the apostrophe). OpenOffice won't match the string 1269 with the number 1269.

Source Link
tohuwawohu
  • 10.8k
  • 1
  • 37
  • 65

Since the formula's structure looks ok, it may be a problem of Function separators. I don't have dutch l11n installed, so i can't test this myself. You may check the formula separators (; or ,) using Tools -> Options -> LibreOffice Calc -> Formula. This is the setting for en_us localization:

enter image description here

If this isn't the reason, you could try to create the formula from scratch using the formula wizard. Since the wizard displays interim results, it may be helpful to narrow down the problem.