Forum Discussion
Solved
Use of $ and fixed cells in arrays
Hi, Is it possible to lock a cell with $ (F4) when you use arrays? The big picture: The function: =IF(AND([@Startdato]>=RIGHT(Tabell1[[#Topptekster];[U32019]];5);[@[Ferdig dato]]...
Thank you SergeiBaklan it worked perfect. Just curious. Somtei,ed it is [@[name] and somtimes it is only @[name] when I choose a cell. Is it any difference in how its used?
Best Gerads
- Geor
Geor, if you reference on only one column in current row that's no difference between [@name] and [@[name]], moreover Excel shall automatically transform the latest into first and shorter variant.
If you reference several columns in the same row (e.g. to sum), then it will be more close to second variant [@[name1]:[name2]].
If you'd like imitate absolute reference for one cell in the current row (not to change if cell is dragged to the left or to the right), when [@[name1]:[name1]]