表1:sheet1
1). 在表1中找出ID号位0928的基因相对应的数值
在相对应的单元格输入:B2=VLOOKUP(A:A,Sheet1!A:D,3,0)
既可以得到:
·······································································································
2)如果要得到表1中个别ID的所有基因相对应的值
在相对应的单元格输入:B2==HLOOKUP(B$1,Sheet1!$A$1:$L$11,ROW(A2),0)
既可以得到: