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 go...
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Apr 23, 2018

    Hi Frederic,

     

    To fix the column you may use

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

     

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Apr 23, 2018

Hi Frederic,

 

To fix the column you may use

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

 

Resources