°ÝÃD:¦p¦ó±Nvlookup¤¤ªº¤u§@ªí¦WºÙ¥ÎÀx¦s®æ¨ú¥N?
=VLOOKUP($A5,'20170214'!$A$1:$Z$2000,3,FALSE)
³o¬O¤u§@ªíSHEET1Àx¦s®æD4ªº¤º®e
20170214¬O¥t¤@ÓSHEETªº¦WºÙ
§Ú·Qn±N¤½¦¡¤¤¸Ìªº'20170214'!§ï¦¨'$D$1'!
Åܦ¨=VLOOKUP($A5,'$D$1'!$A$1:$Z$2000,3,FALSE)
¤£ª¾¹D¨ºÃ䦳¿ù¡A«ç»òµLªk°õ¦æ
½Ð¤j®aÀ°¦£¤@¤U§a¡A¸U¤À·PÁ |