Forum Discussion

FREDERIC SZUCS's avatar
FREDERIC SZUCS
Copper Contributor
Apr 23, 2018
Solved

left/right copy of table[col1]

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

  • Hi Frederic,

     

    To fix the column you may use

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

     

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    Hi Frederic,

     

    To fix the column you may use

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

     

Resources