[算表] 自動尋找符合之條件並回傳資料
軟體:Excel
版本:2016
請問假如工作表1為
http://imgur.com/a/pbrsB
有三間公司與年份
若我想從年份的後兩碼 去工作表2判斷 並回傳資料填回工作表1
http://imgur.com/a/hOJjl
(意思是若工作表1 公司1年份為1997，則末兩碼為97
他會自動去工作表2找A[95]、A[96]、A[97]並填回公司1的前二年、前一年、當年)
有比較迅速的指令寫法嗎？
我爬過相關文章，都是以VLOOKUP或HLOOKUP去解決
但是我不會下條件的句子...
而且假如只有幾筆我可以手動解決...但有上萬筆資料...
跪求大大幫忙
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 140.115.78.186
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1489630922.A.28D.html
→
03/16 10:34, , 1F
03/16 10:34, 1F
→
03/16 10:34, , 2F
03/16 10:34, 2F
→
03/16 10:38, , 3F
03/16 10:38, 3F
→
03/16 10:40, , 4F
03/16 10:40, 4F
→
03/16 10:43, , 5F
03/16 10:43, 5F
→
03/16 10:50, , 6F
03/16 10:50, 6F
→
03/16 10:51, , 7F
03/16 10:51, 7F
→
03/16 11:02, , 8F
03/16 11:02, 8F
→
03/16 11:02, , 9F
03/16 11:02, 9F
→
03/16 11:02, , 10F
03/16 11:02, 10F
→
03/16 11:02, , 11F
03/16 11:02, 11F
→
03/16 11:11, , 12F
03/16 11:11, 12F
→
03/16 11:12, , 13F
03/16 11:12, 13F
→
03/16 11:13, , 14F
03/16 11:13, 14F
→
03/16 11:14, , 15F
03/16 11:14, 15F
→
03/16 11:14, , 16F
03/16 11:14, 16F
→
03/16 11:15, , 17F
03/16 11:15, 17F
→
03/16 16:43, , 18F
03/16 16:43, 18F
→
03/17 16:07, , 19F
03/17 16:07, 19F
→
03/17 16:07, , 20F
03/17 16:07, 20F
→
03/17 16:07, , 21F
03/17 16:07, 21F
→
03/17 16:07, , 22F
03/17 16:07, 22F
→
03/17 16:20, , 23F
03/17 16:20, 23F
→
03/17 16:20, , 24F
03/17 16:20, 24F
→
03/17 16:20, , 25F
03/17 16:20, 25F
→
03/17 16:20, , 26F
03/17 16:20, 26F
Office 近期熱門文章
PTT數位生活區 即時熱門文章
