Blogtrottr
Yahoo!奇摩知識+ - 分類問答 - 電腦網路 - 發問中 |
Yahoo!奇摩知識+ - 分類問答 - 電腦網路 - 發問中 |
|
Excel_VLOOKUP語法疑問
Jul 17th 2013, 14:38
小弟我想寫一個搜尋資料的語法 從Sheet2_A欄第2格輸入號碼, 去Sheet1_A欄搜尋相同號碼, 然後找到相對印的D欄的資訊, 找到後顯示在Sheet2_B欄, 請問各位大大,我的語法哪裡寫錯了呢? =VLOOKUP(Sheet2!$A$2,Sheet1!$A$1:$A$100,Sheet1!$D$1:$D$100,FALSE) 已經改了又改...只好在這請教各位~感恩~ http://files.ckcdn.com/attachments/forum/201307/17/214911jrrh5lp3sktter58.jpg http://files.ckcdn.com/attachments/forum/201307/17/215237bep4w4sbke4bsfwi.jpg
This entry passed through the Full-Text RSS service — if this is your content and you're reading it on someone else's site, please read the FAQ at fivefilters.org/content-only/faq.php#publishers. Five Filters recommends: 'You Say What You Like, Because They Like What You Say' - http://www.medialens.org/index.php/alerts/alert-archive/alerts-2013/731-you-say-what-you-like-because-they-like-what-you-say.html
|
|
|
qhhfl3xncebjd
線上遊戲排行榜2013/2014,進擊的巨人線上看,candy crush saga外掛,正妹寫真三圍
qhhfl3xncebjd 發表在 痞客邦 留言(0) 人氣()
留言列表