Excel資料對照抓取 - 7-11
By David
at 2009-01-26T00:00
at 2009-01-26T00:00
Table of Contents
目前手邊有一份資料清單內容如下GK4801Item017-11GK9960Item02NikeGK5072Item03Canon.........現在要在另外一份excel抓取資料假設輸入GK4801就可以自動跑出Item017-11我是用{=IF(A1=[資料清單.xls]Item!$A$1:$A$100,[資料清單.xls]Item!$B$1:$B$100,0)}但是這樣只能抓到第一筆的資料其他的欄位,邏輯判斷都會變成FALSE請問一下有什麼辦法可以解決嗎?...Showmore
Tags:
7-11
All Comments
By Candice
at 2009-01-28T10:58
at 2009-01-28T10:58
Related Posts
這樣的條件辦貸款,可行嗎?
By Tom
at 2009-01-22T00:00
at 2009-01-22T00:00
如果喜歡一個男生卻希望和他交往當男女朋友該怎麼辦
By Yuri
at 2009-01-22T00:00
at 2009-01-22T00:00
7-11買點數不收消費卷有哪為大大能幫忙解答!
By Isabella
at 2009-01-19T00:00
at 2009-01-19T00:00
消費券可用於7-11取貨?
By Sierra Rose
at 2009-01-19T00:00
at 2009-01-19T00:00
7-11工讀生
By Zanna
at 2009-01-17T00:00
at 2009-01-17T00:00