Forum Discussion
Formular changed in MS 365 and lead to error
Hi, I have been using this formula for years now and with Microsoft 365 I get an error message and the formula did not work as requested. This is the formula. The goal is to get a value ...
The formula looks OK. A slightly shorter version:
=WENNFEHLER(SVERWEIS(A8;'offene Re. Sekr. 05.05.2023'!A:S;19;0);"")
or
=XVERWEIS(A8;'offene Re. Sekr. 05.05.2023'!A:A;'offene Re. Sekr. 05.05.2023'!S:S;"")
If this returns FALSCH, the value of A8 must have been found, but the corresponding value in column S was FALSCH...
HansVogelaar Thanks a lot. I will try this. Best Regards Britta