我正在嘗試添加每列的標題，但我的公式出現錯誤。但是當我在沒有標題的情況下使用它時，它作業正常。但是如何使用陣列公式添加標題。
任何幫助將不勝感激。
={"Active","Link","Lake","Temp",Talei","Shmk","Shmtr","Kile";ARRAYFORMULA(IFERROR(VLOOKUP(A5:A,'Sheet2'!$A$2:$J,{3,4,5,6,7,8,9,10},0)))}
uj5u.com熱心網友回復：
嘗試：
={"Active","Link","Lake","Temp","Talei","Shmk","Shmtr","Kile";
ARRAYFORMULA(IFERROR(VLOOKUP(A5:A, 'Sheet2'!$A$2:$J, {3,4,5,6,7,8,9,10}, 0)))}
或者：
={"Active","Link","Lake","Temp","Talei","Shmk","Shmtr","Kile";
ARRAYFORMULA(IFERROR(VLOOKUP(A5:A, 'Sheet2'!$A$2:$J, {3,4,5,6,7,8,9,10}, 0),
{"","","","","","","",""}))}
轉載請註明出處，本文鏈接：https://www.uj5u.com/yidong/365615.html
上一篇：如何從資料中提取所需的文本