Excel_VLOOKUP語法疑問:－線上遊戲排行榜2013/2014,進擊的巨人線上看,candy crush saga外掛,正妹寫真三圍

Blogtrottr

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

You are receiving this email because you subscribed to this feed at blogtrottr.com.

If you no longer wish to receive these emails, you can unsubscribe from this feed, or manage all your subscriptions