Use of $ and fixed cells in arrays

[Geir Hogstad]

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]]<=RIGHT(Tabell1[[#Topptekster];[U32019]];5));"P";"")

The challenge

To keep @Startdato and @[Ferdig dato] when i copy the function by drag it to the right. 

U32019 in D2 should be changed to U32019 in E2. 

Best regards

Geir

[#2 · Accepted solution]

@Geir Hogstad 

Please use like

=IF(AND([@[Startdato]:[Startdato]]>=...

[#3]

Thank you @Sergei Baklan 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

[#4]

@Geir Hogstad 

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]]