Hi,
I have updated from libreoffice 3.4 to 3.6.1, and indirect formulas that where working before now show as result #REF!
=+vlookup($I6;INDIRECT("‘worker “&$B6&”’!$g$8:$S$31");$Summary.J$4;0)
This formula would search in different worker sheets (number of worker being in this case in B6, from the table g8:s31 the position indicated at j4.
What has changed in the formula that now the result is wrong?
Thanks in advance for your help.
=+vlookup($I6;INDIRECT("‘worker “&$B6&”’!$g$8:$S$31");$Summary.J$4;0)
=+vlookup($I6;INDIRECT("‘worker “&$B6&”’.$g$8:$S$31");$Summary.J$4;0)
Thanks a lot for telling me how to correct it.
Is there any special reason why the syntaxis changed?
Gracias por tu gran respuesta, sabes por qué se cambió la sintaxis?
You have been using ExcelA1 syntax with 3.4. It seems that your user profile setting has not been migrated. If you just switch the formula syntax back again to ExcelA1 your formula will be correct again.