[算表] VLOOKUP 卡2個條件作法?
軟體:EXCEL
版本:2010
表1
日期 品名 總數
2/17 GEE 10
2/17 GUGU 8
2/18 MARY 12
2/18 GEE 20
表2
日期 2/17 2/18
品名
GEE 10 20
GUGU 8
MARY 12
工作上遇到這樣的問題
在表2的"品名"為手動輸入，希望能帶出各日期在表1相對應的數量
嘗試過用VLOOKUP 但數量不在表1第一欄...我不知該如何變化
嘗試用INDIRECT+MATCH 也做不出來Orz
陣列則是不懂怎運用..
還請各位高手指點指點
感謝
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 1.172.56.141
→
05/01 22:05, , 1F
05/01 22:05, 1F
推
05/01 23:24, , 2F
05/01 23:24, 2F
→
05/01 23:37, , 3F
05/01 23:37, 3F
→
05/01 23:37, , 4F
05/01 23:37, 4F
推
05/01 23:51, , 5F
05/01 23:51, 5F
→
05/01 23:51, , 6F
05/01 23:51, 6F
→
05/01 23:51, , 7F
05/01 23:51, 7F
推
05/01 23:53, , 8F
05/01 23:53, 8F
→
05/01 23:54, , 9F
05/01 23:54, 9F
推
05/01 23:55, , 10F
05/01 23:55, 10F
→
05/02 00:02, , 11F
05/02 00:02, 11F
→
05/02 00:03, , 12F
05/02 00:03, 12F
推
05/02 00:03, , 13F
05/02 00:03, 13F
→
05/02 00:03, , 14F
05/02 00:03, 14F
→
05/02 00:59, , 15F
05/02 00:59, 15F
→
05/02 13:45, , 16F
05/02 13:45, 16F
→
05/02 18:03, , 17F
05/02 18:03, 17F
→
05/02 18:04, , 18F
05/02 18:04, 18F
→
05/03 10:16, , 19F
05/03 10:16, 19F
→
05/03 10:18, , 20F
05/03 10:18, 20F
→
05/03 10:19, , 21F
05/03 10:19, 21F
→
05/03 12:59, , 22F
05/03 12:59, 22F
→
05/03 19:31, , 23F
05/03 19:31, 23F
→
05/03 19:44, , 24F
05/03 19:44, 24F
Office 近期熱門文章
PTT數位生活區 即時熱門文章