ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] vba¤¤°õ¦ævlookup°Ê§@

[µo°Ý] vba¤¤°õ¦ævlookup°Ê§@

§Ú·Q¦bsheet(data)ªºcell e1 vlookup sheet(order)ªºcell a1:e100 ªº²Ä¤­¦æ¦p¤U¡A¥i¥H«ç¼g©O?
=vlookup(E1,order!A1:E100,5,False)

Thank you!

¦^´_ 1# apao2000

À³¸Ó¬O³o¼Ë§a

       = vlookup(E1,order!A1:E100,5,False)
-->=application.vlookup(range("E1"),worksheets("order").range("A1:E100"),5,0)
¥Î¥\¨ì¥@¬É¥½¤é¨º¤@¤Ñ¡ã¡ã¡ã

TOP

        ÀR«ä¦Û¦b : ¦Y­W¤F­W¡B­WºÉ¤Ü¨Ó¡A¨ÉºÖ¤FºÖ¡BºÖºÉ´d¨Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD