Forum Discussion
@ appears in my sheet reference formula - macro
Hi everyone =INDEX(Notes!K5:K122,(MATCH(1,IF(Notes!$H$5:$H$122<=Sheet2!C6,IF(Notes!$I$5:$I$122>=Sheet2!C6,1)),0))) So I have the above formula and i am trying to populate the same in a cell u...
This is a new feature introduced in Office 365 Version 1912 wich is used with dynamic array formulas.
I have written an article about this, it is in Turkish however you can use translated page as below.
https://translate.google.com/translate?sl=auto&tl=en&u=http%3A%2F%2Fexcelileharikalar.com%2Findex.php%2F2020%2F02%2F20%2Fbelirsiz-belirli-kesisim-ve-isleci%2F