left/right copy of table[col1]

[FREDERIC SZUCS]

Hi,

I have a table named table1 with column col1, col2, col3.

In cell A2 I use for exemple (french function name) :

= recherchev(A1 ; table1[col1] ; 1 ; false )

when I copy this into cell B2 I got

= recherchev(B1 ; table1[col2] ; 1 ; false)

How cant I get a right /left copy of the A2 cell in B2 that do not change the column name ?

in B2 I want to have 

=recherchev(B1 ; table1[col1] ; 1 ; false)

 many thanks

[#2 · Accepted solution]

Hi Frederic,

To fix the column you may use

= recherchev(A1 ; table1[[col1]:[col1]] ; 1 ; false )