VLOOKUP函数返回多列

品种编码103105106106106118118119119120120129130130135135138139140品种编码103105106106106118118119119120120129130130135135138139140=VLOOKUP($A2,$H:$L,{2,3,4,5},0)=VLOOKUP($A3,$H:$L,{2,3,4,5},0)=VLOOKUP($A4,$H:$L,{2,3,4,5},0)VLOOKUP 只能选一列，后面几列都不起做用。想要做成下列格式：10 X 300/40D 84 X 52 3/1左斜 特深蓝10 X 10 80 X 46 3/1右斜 靛蓝10 X 5.5 X 64 X 48 10 X 5.5 X 64 X 48 10 X 5.5 X 64 X 48 RMB+6/M=VLOOKUP($A2,$H:$L,{2,3,4,5},0)=VLOOKUP($A3,$H:$L,{2,3,4,5},0)=VLOOKUP($A4,$H:$L,{2,3,4,5},0)HKD/YUSD/Y品种等级=VLOOKUP($A2,$H:$L=VLOOKUP($A2,$H二等拼件=VLOOKUP($A3,$H:$L=VLOOKUP($A3,$H二等品=VLOOKUP($A4,$H:$L=VLOOKUP($A4,$H一等品二等品一等品一等品二等品一等品二等品一等品二等品一等品一等品二等品一等品二等品一等品一等品一等品RMB+6/M15.164215.048251216.690264616.690264616.6902646HKD/YUSD/Y品种等级11.75096989830511.52375214065934二等拼件11.66111940447461.5121011975033二等品12.93354063579661.67709647804835一等品12.93354063579661.67709647804835二等品12.93354063579661.67709647804835一等品一等品二等品一等品二等品一等品二等品一等品一等品二等品一等品二等品一等品一等品一等品期末库存(米)83.6736.21231.75228.8751.6963.83972.854586.1478.46107.3750.323.31231.8182.11190.285.4212.9794.4243.06101B102103105106106A106B116118118B118C129135139A141152153153P157品种编码期末库存(米)83.6736.21231.75228.8751.6963.83972.854586.1478.46107.3750.323.31231.8182.11190.285.4212.9794.4243.06101B102103105106106A106B116118118B118C129135139A141152153153P157品种编码棉布名称10 X 10 80 X 46 3/1右斜 靛蓝12 X 7 68 X 46 3/1右斜 蓝加黑10 X 300/40D 84 X 52 3/1左斜 特深蓝10 X 5.5 X 64 X 48 10 X 5.5 64 X 48 3/1右斜 蓝加黑10 X 5.5 64 X 48 3/1右斜 特深蓝(10 + 8竹) X 7 72 X 44 2/1右斜 特深蓝(10 + 8竹) X (7 + 7竹) 72 X 44 2/1右斜 特深蓝(10 + 8竹) X (10 + 9竹) 72 X 42 2/1右斜 特深蓝(10 + 8竹) X (7 + 7竹) 72 X 45 2/1右斜 特深蓝10 X 7 80 X 46 3/1右斜 靛蓝(10 + 10竹) X 16/40D 85 X 52 2/1左斜 特深蓝10 X 7 78 X 48 3/1破斜纹 特深蓝10 X 10 80 X 48 3/1右斜 靛蓝7 X 7 72 X 44 3/1右斜 靛蓝12 X 16 78 X 44 2/1右斜 靛兰12 X 16 78 X 44 2/1右斜 涂层(10 + 6) X 16/40D 75 X 46 2/1右斜 特深蓝615.1642RMB+615.154731215.048251216.690264616.690264616.690264616.466532317.174233315.609420817.277693316.193059716.594543616.525503715.177819217.755261313.000110913.628315415.9632285棉布名称10 X 10 80 X 46 3/1右斜 靛蓝12 X 7 68 X 46 3/1右斜 蓝加黑10 X 300/40D 84 X 52 3/1左斜 特深蓝10 X 10 80 X 46 3/1右斜 靛蓝10 X 5.5 X 64 X 48 10 X 5.5 64 X 48 3/1右斜 蓝加黑10 X 5.5 64 X 48 3/1右斜 特深蓝(10 + 8竹) X 7 72 X 44 2/1右斜 特深蓝(10 + 8竹) X (7 + 7竹) 72 X 44 2/1右斜 特深蓝(10 + 8竹) X (10 + 9竹) 72 X 42 2/1右斜 特深蓝(10 + 8竹) X (7 + 7竹) 72 X 45 2/1右斜 特深蓝10 X 7 80 X 46 3/1右斜 靛蓝(10 + 10竹) X 16/40D 85 X 52 2/1左斜 特深蓝10 X 7 78 X 48 3/1破斜纹 特深蓝10 X 10 80 X 48 3/1右斜 靛蓝7 X 7 72 X 44 3/1右斜 靛蓝12 X 16 78 X 44 2/1右斜 靛兰12 X 16 78 X 44 2/1右斜 涂层(10 + 6) X 16/40D 75 X 46 2/1右斜 特深蓝615.1642RMB+615.154731215.048251216.690264616.690264616.690264616.466532317.174233315.609420817.277693316.193059716.594543616.525503715.177819217.755261313.000110913.628315415.9632285HKD/Y11.74363238074584.6494915254237311.750969898305111.661119404474612.933540635796612.933540635796612.933540635796612.76016706366113.30857536412.095978287728813.388748096203412.548248974305112.859364972745812.805864901084711.761523624135613.75882282433910.073984243186410.560789493016912.3701492715254USD/Y1.522800682338460.6029010989010991.523752140659341.51210119750331.677096478048351.677096478048351.677096478048351.654615069793411.725727354892311.568489492254951.736123379507691.627135581283521.667478095367031.660540723437361.525120645767031.784111091507691.306296857907691.369421055138461.60404133410989HKD/Y11.74363238074584.6494915254237311.750969898305111.661119404474612.933540635796612.933540635796612.933540635796612.76016706366113.30857536412.095978287728813.388748096203412.548248974305112.859364972745812.805864901084711.761523624135613.75882282433910.073984243186410.560789493016912.3701492715254USD/Y1.522800682338460.6029010989010991.523752140659341.51210119750331.677096478048351.677096478048351.677096478048351.654615069793411.725727354892311.568489492254951.736123379507691.627135581283521.667478095367031.660540723437361.525120645767031.784111091507691.306296857907691.369421055138461.60404133410989