Hello,

I have two files;

File1

*ID_REF VALUE1 VALUE2 VALUE3*

ILMN_1762337 5.650968 5.296173 5.310465

ILMN_2055271 5.457874 5.513952 5.453695

ILMN_1736007 5.159924 5.342681 5.364833

ILMN_2383229 5.564290 5.589798 5.389733

and File 2

ID_REF gene-symbol

ILMN_1673207

ILMN_1673214

ILMN_1673215 PCBP1

ILMN_1673222 ZBTB10

ILMN_1673224

ILMN_1673232 CERS1

ILMN_1673234 PKDREJ

ILMN_1673238 CLEC9A

ILMN_1673241

how I can have a file containing columns of file 1 (except for column 1) and matched column 2 from file 2 (the columns 1 from both files are the same, I need matched gene-symbol.